Table of contents
Collapse the table of content
Expand the table of content

RepaintObject, ShowAllRecords, Requery, and Refresh Action/Method Comparison

office 365 dev account|Last Updated: 4/3/2018
3 Contributors

Applies to: Access 2013 | Access 2016

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

Action or MethodDescription
RepaintObject action
DoCmd.RepaintObject, Repaint methodUse 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
ShowAllRecords methodUse 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 methodUse 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 methodUse 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

© 2018 Microsoft