Full Version: Show ComboBox based on selection in Different ComboBox
UtterAccess Forums > Microsoft® Access > Access Forms
jujubean
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?
Thanks.
theDBguy
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
HTH.
jujubean
Thanks. It worked great.
theDBguy
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.