Edit

RepaintObject, ShowAllRecords, Requery, and Refresh action/method comparison

  • Article

The following table provides a brief comparison of the RepaintObject action, DoCmd.RepaintObject method, Repaint method, ShowAllRecords action, DoCmd.ShowAllRecords method, Requery action, DoCmd.Requery method, Requery method, and Refresh method.

Action or method Description
RepaintObject action, DoCmd.RepaintObject method, Repaint method Use the RepaintObject action, RepaintObject method or Repaint method to repaint controls in the specified object. They don't requery the database or display new records.
ShowAllRecords action, DoCmd.ShowAllRecords method Use the ShowAllRecords action to requery and display the most recent records and remove any applied filters, which the Requery action doesn't do.
Requery action, DoCmd.Requery method Use the Requery action or method to requery the source of the object or one of its controls.

The Requery action or method does one of the following: Reruns the query on which the control or object is based, displays any new or changed records, and removes any deleted records from the table on which the control or object is based.
Refresh method Use the Refresh method to immediately update the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment. The Refresh method shows only changes that have been made to the current set of records; it doesn't reflect new records or deleted records in the record source.
Requery method Use the Requery method to update the data underlying a form or control to reflect records that are new to or have been deleted from the record source since it was last requeried. If you want to requery a control that isn't on the active object, you must use this method, not the Requery action or its corresponding DoCmd.Requery method.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.