Full Version: Show ComboBox based on selection in Different ComboBox
UtterAccess Forums > Microsoft® Access > Access Forms
I have a form with five comboboxes. In the first, the user can select one of four items. The other four comboxes are hidden. Based on the selection made in combobox one, I would like one of the comboxes to be visible, and the other three to remain hidden.
Any suggestions?
In the AfterUpdate event of the combo box, you can use a Select statement and set the conditions as required:
Select ComboBox1
Case 1
Me.ComboBox2.Visible = True
Me.ComboBox3.Visible = False
Case 2
End Select
Thanks. It worked great.
You're very welcome. Good luck.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.