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.
Example
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.