DoCmd.ShowAllRecords

Remove any applied filter from the active table, query result set, or form, and display all records.

Syntax
      Docmd.ShowAllRecords

The ShowAllRecords action doesn’t have any arguments.

Examples

DoCmd.ShowAllRecords

“To be without some of the things you want is an indispensable part of happiness” ~ Bertrand Russell

Related

SetFilter - Apply a filter to the records being displayed.