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 Method | Description |
|---|---|
| RepaintObject action DoCmd.RepaintObjectRepaint 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 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 |
|