Show ComboBox based on selection in Different ComboBox

[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.

[DavidB]

On Aug 16, 11:43 am, jujubean <[e-mail]:

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.

[Ben]

On Aug 16, 8:43 am, jujubean <[e-mail]:

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