filtering combo boxes (access 2k)

Topic

New Reply

I have a form that has two combo boxes. One has states and the other has cities. Is there a way that once I select a state the cities combo box get filtered for only those cities in that state?

Reply | Quote

Replies

In the query behind the Cities combobox add a column for the State with a criteria that the State would equal the value of the States combobox. So the criteria would look something like this for the State field: Forms!frmCityStateSelect!cboState. Then in the after_update event for the State combobox you would requery the City combobox: Me!cboCity.Requery

Reply | Quote