Others

Refresh a Microsoft Access Query After Changing Combo Box Criteria

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

Question details

The user needs to refresh a Microsoft Access 2016 query after changing combo box criteria so the query displays the newly selected value without using Refresh All.

Refresh a Microsoft Access Query After Changing Combo Box Criteria
Product
Microsoft Access 2016
Device & OS
not provided
Scenario
An Access 2016 query uses a combo box value as filter criteria. After changing the selection, the query should update immediately to show matching records.
Observed behavior
The first search returns results, but changing the combo box selection does not update the displayed records until the user manually uses Refresh All.
Before you start

Confirm whether the query is opened directly as a datasheet or bound to a form, and identify the combo box event that changes the criteria. This determines whether you should close and reopen the query or requery the form.

Solution 1Recommended

Close and Reopen a Directly Displayed Access Query After Criteria Change

Use this when the query results are opened directly as a separate datasheet; closing it before reopening forces Access to re-evaluate the combo box criteria.

If the query is displayed directly rather than through a form, Access may cache the previous result set. Closing the query object with DoCmd.Close before running it again clears that cached view so the new criteria take effect.

1
Open the VBA code for the combo box

In Access, open the form in Design View, select the combo box, and open the property sheet. Go to the Event tab and click the build button next to After Update to open the VBA editor.

2
Add DoCmd.Close for the query

In the AfterUpdate procedure, enter DoCmd.Close acQuery, "YourQueryName" before the command that opens or refreshes the query.

3
Reopen the query

On the next line, use DoCmd.OpenQuery "YourQueryName" to run the query again with the updated criteria.

Close and Reopen a Directly Displayed Access Query After Criteria Change
Direct refresh without Refresh All: This method directly applies the selected combo box value and avoids requiring the Refresh All command.
Free Microsoft Office alternative

Use WPS Office as a Free, Lightweight Alternative for Data Filtering Tasks

If Access query refresh issues disrupt your workflow, WPS Office offers a free, lightweight alternative for common data filtering and analysis. It opens Excel and CSV exports from Access with familiar ribbon tools, making migration easier while maintaining Microsoft Office file compatibility.

  1. 1. Download WPS Office: Go to the official WPS Office website, click Download WPS Office Free, and install it on your computer.
  2. 2. Open your Access export: In WPS Spreadsheets, open the .xlsx or .csv file exported from Microsoft Access.
  3. 3. Apply criteria-based filters: Select the data range, open the Data tab, and use Filter or lookup functions to display rows that match the changed criteria.
Free and lightweight Microsoft Office alternative for everyday data tasksOpens and saves Microsoft Excel .xlsx and .csv formatsFamiliar ribbon interface reduces learning time for Access usersUse WPS Spreadsheets filters and lookup functions to reproduce criteria-based filteringSeamless migration from Access exports without database overhead
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access query still show old records after I change the combo box?

Access may be displaying a cached query result. If the query is opened directly, close it with DoCmd.Close before DoCmd.OpenQuery. If it is bound to a form, use Me.Requery in the combo box AfterUpdate event.

Where do I add the code to refresh the query automatically?

Open the form in Design View, select the combo box, open the property sheet, and click the Event tab. Add the refresh code to the After Update event procedure.

Should I bind the query to the form or reference the combo box column in the query?

Binding the query to the form is usually simpler. Directly referencing a combo box column in the query can cause complexity errors, as reported in this Access scenario.

Does WPS Office include Microsoft Access or repair Access query refresh issues?

No, WPS Office does not include Microsoft Access and cannot repair Access itself, but it can be a free alternative for opening exported Excel/CSV data and applying criteria-based filters in WPS Spreadsheets.

Can WPS Office open .accdb or .mdb Access database files?

WPS Office does not open Access database files directly. Export the data from Access to .xlsx or .csv and open that file in WPS Spreadsheets.