Combo Box dependent on other ComboBox

  • Thread starter Thread starter Bobby Bosco
  • Start date Start date
B

Bobby Bosco

I thought I had seen this here but I cannot find it.

I have a contract form. On this contract form 1 to 6
names can be on it. The 6 names are in a query that
powers the combo boxes. I would like to have COMBO1
displayed so that the data entry person can only select it.

Then if C1 is selected, display C2 so that a second name
can be selected. However, when the dropdown for C2 is
displayed, the name in C1 doesn't show up.

How can I do such a thing?

tia

Bobby
 
What I meant to say (read before posting...) is that
when the user selects the dropdown in C2, I DON'T want the
name in C1 to show up.
 
Bobby,

You don't want to do it this way!

You wnat to use a multiselect listbox where you can select multiple values in
the same listbox. Just create a listbox that displays your six names. Then go to
properties and set the multiselect property to simple. You will then be able to
select C1 and C2 at the same time.
 
Back
Top