How to Dynamically Filter a Microsoft Access List Box or Combo Box
Question details
The user wants to dynamically filter a Microsoft Access list box or combo box so that selecting a country updates the related states or regions in a second control.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A Microsoft Access form should display related states or regions and their counts after a country is selected.
- Observed behavior
- The second combo box or list box does not update automatically when the first control changes.
Check that the countries and regions are stored in related tables with a foreign key such as CountryID, and open the form in Design View so you can edit the Row Source and After Update event.
Filter an Access List Box or Combo Box with a Cascading Row Source Query
Use this when the second combo box or list box must show only records related to the value selected in the first control.
Cascading combo boxes rely on a parent-child table relationship. The second control is filtered by a query that references the first control on the open form, so it refreshes when the first control changes.
Open the Microsoft Access database, right-click the form in the Navigation Pane, and choose Design View.
Click the second combo box or list box whose data should update, then open the Property Sheet.
On the Data tab, set Row Source to a query such as SELECT RegionID, Region FROM tblRegions WHERE CountryID = Forms!YourFormName!cboCountry;.
Open the Property Sheet for the first combo box, go to Event > After Update, click the build button, choose Code Builder, and add Me.SecondControlName.Requery.

Link the Countries and Regions Tables with a Foreign Key Before Filtering
Use this when the second control returns no matching rows or when the data model does not yet link countries and regions.
Use WPS Office as a Free, Lightweight Alternative for Everyday Office Tasks
Microsoft Access handles relational forms, but WPS Office provides a free, lightweight suite for documents, spreadsheets, and presentations with familiar menus, strong Microsoft Office format compatibility, and easy migration when your team does not require Access databases.

Frequently Asked Questions
How do I make the second combo box update after selecting a country?
Set the second control's Row Source to a query with WHERE CountryID = Forms!YourFormName!cboCountry, and add Me.SecondControl.Requery to the first combo box's After Update event.
Do cascading combo boxes require related tables?
Yes, use a Countries table and a Regions table where CountryID is a foreign key. This preserves normalization and makes filtering reliable.
Which field should I bind in the second combo box?
Bind only the identifying field such as RegionID. Storing country and region as well would create redundant data and violate Third Normal Form.
Why does my second list box still show all records?
The Row Source probably does not reference the first control correctly, or the first combo box is not running Requery in its After Update event.
Can WPS Office open Microsoft Access forms?
No, WPS Office does not include a Microsoft Access replacement. It supports Word, Excel, and PowerPoint-compatible files for daily document, spreadsheet, and presentation work.




