Comboc criteria...Open and display combobox 2

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi again…

I have this question.

Combobox 1. Fruits
Combobox 2.

If (Me.Fruits = “Bananasâ€) Then open and highlight the options
available/sub index in Combobox 2…in this case Doyle, Chequita, etc etc?

Thanks!
 
Hi again¡K

I have this question.

Combobox 1. Fruits
Combobox 2.

If (Me.Fruits = ¡§Bananas¡¨) Then open and highlight the options
available/sub index in Combobox 2¡Kin this case Doyle, Chequita, etc etc?

Thanks!
Click to expand...


Combo2 should only show the options available if Bananas is chosen,
not the options available for all fruits.

Leave the Combo2 Rowsource property blank.

Code the Combo1 AfterUpdate event:
Me.Combo2.Rowsource = "Select TableName.[Option] From TableName Where
TableName.[Fruit] = '" & Me![Combo1] & "'"

When you select a fruit in Combo1 it will then load Combo2 with
whatever options (Companies?) are associated with just that fruit.
 
Back
Top