Refresh a Microsoft Access Query After Changing Combo Box Criteria
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.

- 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.
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.
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.
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.
In the AfterUpdate procedure, enter DoCmd.Close acQuery, "YourQueryName" before the command that opens or refreshes the query.
On the next line, use DoCmd.OpenQuery "YourQueryName" to run the query again with the updated criteria.

Requery the Form When the Query Is Bound to a Form
Use this if the query feeds a form, because requerying the form re-runs its record source and updates the displayed records.
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. Download WPS Office: Go to the official WPS Office website, click Download WPS Office Free, and install it on your computer.
- 2. Open your Access export: In WPS Spreadsheets, open the .xlsx or .csv file exported from Microsoft Access.
- 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.

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.




