View Full Version : about validation rules


afnan_88
07-06-2010, 11:39 AM
hello everybody

i want to have more than one validation rule to my table

how can i do that? (should i sepreate them by "and")

other ques.
how can i write the following expression as a validation rule for my table:

if i enter 1 in field1 then, field2 must be 3 otherwise it must be 1



thanx in advance

PNGBill
07-06-2010, 12:30 PM
You may not even need a validation rule on your table.

Assuming all data is entered by Form, then you can have the validation on a form.
This will give you better control of the validation as you can have simple validation in the forms text box control or more complex with an event driven vba code.