Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Requery Or Refresh Data. To refresh the records in Datasheet or Form view click Refresh on the Records menu. The Requery method updates the data underlying a form or control to reflect records that are new to or deleted from the record source since it was last queried.
Access 2013 Navigation Tab Requery Issue Microsoft Community from answers.microsoft.com
Dim lngEmployeeID As Long lngEmployeeID Nz MeEmployeeID0. In an Access project adp the Refresh method requeries the database and displays any new or changed records or removes deleted records from the table on which the form is based. If you want to stay on the record which was current before the code was executed youd need to include some further code.
Either Refresh or Requery should do it.
The Refresh method shows only changes that have been made to the current set of records. Requery essentially re-runs the query that pulled the data into the form in the first place. Requery method updates all the data present in the control or forms to show all the records which get added or deleted from the record source from the time it last queried. You can also use requery to update the data in a list box or combo box.
