Others

How to Filter a Microsoft Access Subform via Combo Box Value

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to filter continuous subforms in Microsoft Access based on a designer or status selected from a header combo box.

Product: Microsoft Access
Device & OS: not provided
Scenario: Dynamically filtering database records displayed in a subform by selecting a specific value from a combo box on the main parent form.
Observed behavior: The continuous subform must update to show only records matching the specific status (such as Job Briefed) chosen in the header combo box.

Before you start

Verify the exact names of your main form, subform control, and header combo box, as you will need these to properly set up the query parameters and VBA code.

Solution 1Recommended

Filter the Subform Using a Query and the After Update Event

This method links the subform's underlying query to the combo box and uses a simple VBA command to refresh the data whenever a new value is selected.

To achieve dynamic filtering, you must base your subform on a query rather than directly on a table. The query will use the combo box as a parameter to filter the results. Once the query is set, you force the subform to refresh its data using the combo box's After Update event.

Modify the Subform's Underlying Query

Open the query that powers your subform in Design View. In the 'Criteria' row under the field you want to filter (e.g., Designer or Status), enter the reference to your combo box using the syntax: [Forms]![YourMainFormName]![YourComboBoxName].

Access the Combo Box Event Properties

Open your main form in Design View. Click on the header combo box to select it, then open the Property Sheet (F4). Navigate to the 'Event' tab, click on the 'After Update' row, select '[Event Procedure]' from the dropdown, and click the three dots (...) to open the VBA editor.

Add the Requery VBA Code

In the VBA editor, type the command to requery the subform. The syntax should be: Me.YourSubformControlName.Requery. Ensure you use the name of the control that houses the subform on the main form, not the name of the subform object itself.

Save and Test the Filter

Save your VBA code and form design. Switch the main form to Form View. Select a different value from your header combo box; the subform should immediately refresh to display only the records matching your selection.

Target the Subform Control Container: A common mistake is attempting to requery the form object. You must requery the subform control (the container on the parent form that holds the subform) for the data to refresh correctly.

Free Microsoft Office alternative

Looking for a Lightweight Alternative for Your Office Tasks?

While WPS Office does not include a complex relational database tool like Microsoft Access, it is an exceptional, free alternative for your everyday document, spreadsheet, and presentation needs. It offers a familiar interface and excellent compatibility for users migrating from Microsoft Office.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Install and Launch: Follow the on-screen instructions to install the suite, which takes only a few minutes.
3. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, and PowerPoint files without formatting loss.

Easily manage flat-file data lists, records, and filters using WPS Spreadsheet as a lightweight alternative to complex databases.Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Lightweight installation that runs smoothly across Windows, Mac, Linux, iOS, and Android.Familiar user interface ensuring a seamless transition with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't my Access subform updating when I change the combo box selection?

This usually occurs if the combo box's 'After Update' event is not properly triggering the requery action, or if your VBA code is targeting the form object instead of the subform control container on the parent form.

How do I correctly reference a main form's combo box in a query criteria?

In the query design view, enter the exact path to the control in the Criteria row: [Forms]![MainFormName]![ComboBoxName]. Ensure all form and control names are spelled exactly as they appear in their property sheets.

What is the difference between a subform object and a subform control?

The subform object is the actual form you designed and saved in the navigation pane. The subform control is the specific container element placed on the parent form that holds and displays the subform object.

Office Quick Solutions