How to Refresh a VBA Query in Access

In a few steps, you can write VBA code to refresh a query in Access.

Knowing how to refresh a Microsoft Access query in Visual Basic for Applications (VBA) is important when you have controls displaying information through a query. An Access query is written in structured query language (SQL). You can write SQL queries in VBA to access information in relational databases such as the ones in Access. As you update information in a table, you also want to refresh the information displayed in your control. In just a few steps, you can write a sub to refresh a query in VBA.

Instructions

1. Start Microsoft Access 2007 and click the "Create" tab. Click on "Table," type "Smith" and press "Enter" to add a new record. Save the table as "Table1." Click "Create" and select "Form Design" to create a new form.

2. Add a new "List Box" control from the "Controls" menu. Add a new "Button" control to the form.

3. Right-click anywhere on the form and select "Properties." Select "Form" on "Selection type" and select the "Event" tab. Select "[Event Procedure]," next to "On Load," and click the ellipsis to open Microsoft Visual Basic.

4. Type the following to define a query for your list box control:

   Me.List0.RowSource = "SELECT Table1.Field1 FROM Table1;."

5. Switch windows to Microsoft Access and right-click the button control. Select "Properties" and click the "Event" tab. Select "[Event Procedure]," next to "On Click," and click the ellipsis.

6. Type the following to refresh the query:

   Me.List0.Requery.

7. Switch Windows to Microsoft Access and click on "View" to run the form. You will see "Smith." Open "Table1" and type "Jones" on the second row to enter a new record. Save and close "Table1." Click the "Command" button on your form to refresh the query in your list box control.

References

• Microsoft : Requery Method