HELP - Function question for Table problem

[Sandi]

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

 

[strive4peace]

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

*

 

[KARL DEWEY]

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