combo box dependency

A

Aaron

Hello,

I have a form with 20 combo boxes on it for data entry. There are times
when my people need to move to a new record without completing the first
record, so I don't have "REQUIRED" set for all combos. However, I'd like to
somehow tell Access (I'm assuming via code) that:

Combo Box "station" must be filled in if Combo Box "dept" has "upholstery"
as the selection. Can someone help?

Thank you much,
Aaron
 
S

Steve Schapel

Aaron,

Go to the design view of the table that the form is based on, and select
Properties from the View menu. In the Validation Rule property, put:
[dept]<>"upholstery" Or ([dept]="upholstery" And [station] Is Not Null)
In the Validation Text property, put whatever you want the message to
pop up if the rule is not complied with.
 
Top