By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Show ComboBox based on selection in Different ComboBox

P: n/a
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.

Aug 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Aug 16, 11:43 am, jujubean <harryzwee...@yahoo.comwrote:
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.
I would only use TWO combo boxes and change the data displayed in teh
2nd based on the current selection in the 1st.

Aug 16 '07 #2

P: n/a
Ben
On Aug 16, 8:43 am, jujubean <harryzwee...@yahoo.comwrote:
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.
Totally, just use two and set the rowsource of the second combo box
after the first is updated. Combo box 1 can even store the query for
the rowsource as part of its own rowsource so setting the source for
box 2 is just a reference to the correct column.

Or, if you must have four combo boxes then just use "if" statements to
turn them on.

if me.combo1 = 1 then
me.combo2.visible = true
end if
if me.combo1 = 2 then
me.combo3.visible = true
end if

Aug 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.