Refresh an Access List Box After Filtering Data
Question details
Refresh an Access list box when the value in an unbound filter text box changes.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A form uses an unbound text box to filter the records displayed in a list box.
- Observed behavior
- The list box remains blank after the filter value changes, even though its query returns the expected records.
Open the form in Design View and check the names of the filter text box and list box in their Property Sheets. Confirm that the list box's Row Source query refers to the filter text box and returns the expected records.
Requery the List Box in the Text Box's After Update Event
Use the text box's After Update event to rerun the list box query whenever the entered filter value is committed.
In Access, open the form in Design View, select the filter text box, and open its Property Sheet. On the Event tab, find After Update.
Set After Update to [Event Procedure], then click the ellipsis button next to the property to open the VBA editor.
Inside the generated procedure, enter Me.[NameOfListBox].Requery, replacing NameOfListBox with the actual list box control name.
Save the form, open it in Form View, enter a filter value, and move focus out of the text box. The After Update event should requery the list box and display matching records.
Work with Office Files in WPS Office
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. WPS Office does not fix Access list box events or replace an Access database.

Frequently Asked Questions
Why does the list box stay blank when its query returns records?
The list box may still be displaying an earlier query result. Add Me.[NameOfListBox].Requery to the filter text box's After Update event so Access reruns the Row Source query after the value is committed.
Where can I find the list box control name?
Open the form in Design View, select the list box, and open the Property Sheet. Check the Name property and use that value in the Requery command.
Why does the list refresh only after I leave the text box?
The After Update event runs when the edited value is committed, typically as focus leaves the text box. It is not triggered by every keystroke.
What should I check if requerying still shows no records?
In Design View, inspect the list box's Row Source and verify that its query references the correct form and filter text box. Also check that the VBA command uses the list box control's actual name.




