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.
The ShowAllRecords action doesn’t use any arguments.
Use this action to ensure that all records (including any changed or new records) are displayed for a table, query result set, or form. This action causes a requery of the records for a form or subform.
You can also use this action to remove any filter that was applied with the ApplyFilter action, the Apply Filter/Sort command on the Records menu, or the Filter Name or Where Condition argument of the OpenForm action.
This action has the same effect as clicking Remove Filter/Sort on the Records menu or clicking the Remove Filter button on the toolbar in Form view or Datasheet view.
To run the ShowAllRecords action in Visual Basic, use the ShowAllRecords method of the DoCmd object.
ApplyFilter Action, OpenForm Action, RepaintObject Action, Requery Action, ShowAllRecords Method.