DoCmd.RefreshRecord

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.

Example

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

Related:

Requery - Requery the data in a form or a control.


© Copyright SS64.com 1999-2013
Some rights reserved