Others

Refresh an Access List Box After Filtering Data

Bushra ParveenBushra Parveen Nov 20, 2026 868 views

Question details

Refresh an Access list box when the value in an unbound filter text box changes.

Refresh an Access List Box After Filtering Data
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the event property

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.

2
Create an event procedure

Set After Update to [Event Procedure], then click the ellipsis button next to the property to open the VBA editor.

3
Add the Requery command

Inside the generated procedure, enter Me.[NameOfListBox].Requery, replacing NameOfListBox with the actual list box control name.

4
Test the filter

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.

When the event runs: After Update runs when an edited text box value is committed, typically when you leave the control; it does not refresh the list after every keystroke.
Free Microsoft Office alternative

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.

Filter and review tabular data in WPS SpreadsheetsOpen and edit Microsoft Office formats including XLSX, DOCX, and PPTXUse a familiar interface for everyday office tasksMove existing Office files into a lightweight, free suite
microsoft office alternative - wps office

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.