ShowAllRecords Method [Access 2003 VBA Language Reference]

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

expression.ShowAllRecords

expression Required. An expression that returns a DoCmd object.

Remarks

This method removes any existing filters that may exist on the current table, query, or form. It can be called directly using the syntax DoCmd.ShowAllRecords.

Note  This method only applies to tables, queries, and forms within a Microsoft database (.mdb).

Applies to | DoCmd Object