Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

HELP - Function question for Table problem

Discussion in 'Information Technology' started by Sandi, Jul 28, 2006.

  1. Sandi

    Sandi
    Expand Collapse
    Guest

    I have a database that has two forms built off of the same tables. I have
    gone in and set up validation rules and text for certain fields in the Table
    not be left blank. The only problem with this is that it affects the other
    Forms that do not require some fields to be filled out. Because I have added
    these validation rules to the table, is there some way that I can distinguish
    between the forms. There is an Inbound and Outbound Form that contain the
    same fields from the Employee Table. Most fields are required for the
    Inbound Form and not for the Outbound form. Is there an IF function that
    state if they are using the Inbound form that this fields is required and an
    IF function for the Outbound form that it's not required???
    Sandi Gardner
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Sandi,

    Instead of putting the validation at the table level where
    it will be different for different forms, remove it from the
    table and put it on the respective controls in each form --
    Data tab of Properties

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Sandi wrote:
    > I have a database that has two forms built off of the same tables. I have
    > gone in and set up validation rules and text for certain fields in the Table
    > not be left blank. The only problem with this is that it affects the other
    > Forms that do not require some fields to be filled out. Because I have added
    > these validation rules to the table, is there some way that I can distinguish
    > between the forms. There is an Inbound and Outbound Form that contain the
    > same fields from the Employee Table. Most fields are required for the
    > Inbound Form and not for the Outbound form. Is there an IF function that
    > state if they are using the Inbound form that this fields is required and an
    > IF function for the Outbound form that it's not required???
    > Sandi Gardner
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    For the fields not required for everything remove the validation from the
    table and set the validation rule in the form text box.

    "Sandi" wrote:

    > I have a database that has two forms built off of the same tables. I have
    > gone in and set up validation rules and text for certain fields in the Table
    > not be left blank. The only problem with this is that it affects the other
    > Forms that do not require some fields to be filled out. Because I have added
    > these validation rules to the table, is there some way that I can distinguish
    > between the forms. There is an Inbound and Outbound Form that contain the
    > same fields from the Employee Table. Most fields are required for the
    > Inbound Form and not for the Outbound form. Is there an IF function that
    > state if they are using the Inbound form that this fields is required and an
    > IF function for the Outbound form that it's not required???
    > Sandi Gardner
     

Share This Page