Refresh or requery data

Microsoft Office Access 2003

Show All Show All

Refresh or requery data

If you are using a Microsoft Access project, or a Microsoft Access database that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records.

In an Access database (.mdb), refreshing records only updates the data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, requery the records.

Note  In an Access project (.adp), the refresh and requery actions both requery the records.

To requery or refresh:

  1. Open a table, query, or form in Datasheet view, PivotTable view, or PivotChart view, or open a form in Form view.
  2. Do one of the following:
    • To refresh the records in Datasheet or Form view, click Refresh on the Records menu.
    • To refresh the records in PivotTable or PivotChart view, click Refresh Button image on the PivotTable or PivotChart toolbar.
    • To requery the records, press SHIFT+F9.