Refresh the data in a form. (Access 2010 +)
Syntax
DoCmd.RefreshRecord
RefreshRecord will update the current records to reflect changes. If a row in the record source has been deleted, it will change to show #Deleted.
RefreshRecord does not requery the database, the current set will not include records that have been added (or hide those that have been deleted) since the database was last queried.
The RefreshRecord method is equivalent to the Refresh method of the Form object.
DoCmd.RefreshRecord
“The rest and the spell of sleep in the middle of the day refresh the human frame far more than a long night” ~ Winston Churchill
Requery - Requery the data in a form or a control.