DoCmd.ShowAllRecords (Access)

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

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.

DoCmd.ShowAllRecords