filtering selections in a combo box

[Colin ward]

This is a really simple question and Im sure I know how
to do it but my brain has seized up.

I want to limit the values in one combo box based on the
selection that is made in another combo box.
Specifically, I want to Limit the selections to Canadian
Provinces or US States depending on whether the user
chooses Canada or the United States as the country.

 

[Armen Stein]

This is a really simple question and Im sure I know how
to do it but my brain has seized up.

I want to limit the values in one combo box based on the
selection that is made in another combo box.
Specifically, I want to Limit the selections to Canadian
Provinces or US States depending on whether the user
chooses Canada or the United States as the country.

In the After Update event for Country, change the RowSource of the
State/Prov combobox to include the appropriate Where clause. Then
requery the State/Prov combobox. You should also set the State/Prov
combobox to Null, since they have changed the higher order selection
anyway.