database design: conditional drop-downs?

[sebeckett]

Hello!


I have two drop-down lookup fields in a form. In the first field, the end user can select either "Red" or "Blue," we'll say. How can i make the second drop-down available ONLY if the user selects "Red" in the first field. If the user selects "Blue," the second drop-down will either be hidden, locked, or made otherwise unavailable for entry.

Thanks!
Sean

[RuralGuy]

You would do it with code in the AfterUpdate event of the 1st ComboBox.

[sebeckett]

Thanks for the tip. I have very little coding experience, and would need help writing an appropriate code for this situation.

[RuralGuy]

Something like:

If Me.cboName = "Blue" Then
   Me.OtherCBOName.Enabled = False
Else
   Me.OtherCBOName.Enabled = True
End If

...using *your* control names of course.

[sebeckett]

works like a charm. thanks very much

[RuralGuy]

Great! Glad we could help.