Straight from querying "Refresh Requery" in the Help screens .. . .
" Refresh or requery data
Show All
Hide All
If you are using a Microsoft Access project (Microsoft Access project:
An Access file that connects to a Microsoft SQL Server database and is used
to create client/server applications. A project file doesn't contain any
data or data-definition-based objects such as tables and views.), or a
Microsoft Access database (Microsoft Access database: A collection of data
and objects (such as tables, queries, or forms) that is related to a
particular topic or purpose. The Microsoft Jet database engine manages the
data.) 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.
"
