CHANGING COMBO BOX OPTIONS

  • Thread starter Thread starter BRENNON
  • Start date Start date
B

BRENNON

I have a form for entering information regarding stores.
I would like to have one combo box dictate the items
available in a different combo box. For instance, if I
chose the state of Pennsylvania in one combo box, I would
like the stores combo box to be limited only to stores
that are in the state of PA. Same with all other
states.

Is this possible? If so... what would the best approach
be?

Any advice would be greatly apprecaited.
 
Brennon,

Use a query for the Row Source of the second combobox. In the criteria
of the State field in this query, put...
[Forms]![NameOfYourForm]![NameOfYourStateCombobox]
.... and on the AfterUpdate event of your State combobox, put this code:
Me.NameOfYourStoresCombobox.Requery
 
Back
Top