Multiple Criteria on Form,CustomerID,EmployeeID,

[burrina]

How can I use vba code to check for many conditions on my form before allowing user to close out Order?



CustomerID
EmployeeID
OrderDate
OrderedBy



and so on ?

[pbaldy]

One way:

http://www.baldyweb.com/BeforeUpdate.htm

repeating the test for each. You can add

Exit Sub

to a failed test to prevent it from testing further if you want.