combo box dependency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top