Others

How to Dynamically Filter a Microsoft Access List Box or Combo Box

Olivia MillerOlivia Miller Nov 13, 2026 870 views

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.

How to Dynamically Filter a Microsoft Access List Box or Combo Box
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the form in Design View

Open the Microsoft Access database, right-click the form in the Navigation Pane, and choose Design View.

2
Select the second combo box or list box

Click the second combo box or list box whose data should update, then open the Property Sheet.

3
Set the Row Source to a filtered query

On the Data tab, set Row Source to a query such as SELECT RegionID, Region FROM tblRegions WHERE CountryID = Forms!YourFormName!cboCountry;.

4
Requery the second control in the first control's After Update event

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.

Filter an Access List Box or Combo Box with a Cascading Row Source Query
Database normalization preserved: Bind only the identifying field such as RegionID to avoid storing redundant country and region data in the main table.
Free Microsoft Office alternative

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.

Free, lightweight Office suite that covers daily document, spreadsheet, and presentation tasks without Access database overheadOpens and saves Microsoft Word, Excel, and PowerPoint-compatible formats including .docx, .xlsx, and .pptxFamiliar ribbon-style interface and menus for easy migration from Microsoft OfficeIncludes WPS Writer, Spreadsheet, and Presentation, making everyday file editing simple
microsoft office alternative - wps office

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.