Making access drop down menus disapear

[slandeck]

Depending on which selection you choose from a drop down menu, how do you make another drop down menu on the same form disapear and re-appear?

 

[Scoty]

Slandeck,
Very simple. In the afterupdate event of you main dropdown menu (your selection menu) you just type:

If MyDropDownMenu = "This String" then 'Set your condition
     Me.SecondaryMenu.Visible = False 'This will make it disappear
End If

This will take a condition and based on the value of the selection will make my SecondaryMenu Disappear. To make a menu appear just use

 Me.ThirtiaryMenu.Visible = True

Hope this helps
Scotty :