DoCmd.ShowAllRecords Method (Access)
The ShowAllRecords method carries out the ShowAllRecords action in Visual Basic.
Syntax
expression .ShowAllRecords
expression A variable that represents a DoCmd object.
Remarks
You can use the ShowAllRecords action to remove any applied filter from the active table, query result set, or form, and display all records in the table or result set or all records in the form's underlying table or query.
Note
This method only applies to tables, queries, and forms within a Microsoft Access database.