DoCmd.ShowAllRecords Method (Access)

The ShowAllRecords method carries out the ShowAllRecords action in Visual Basic.

expression .ShowAllRecords

expression A variable that represents a DoCmd object.

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 Note

This method only applies to tables, queries, and forms within a Microsoft Access database.