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.

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.


© Copyright SS64.com 1999-2013
Some rights reserved