Use the Requery method instead of the Requery action

Provided by Total Access Analyzer

Use the Requery method instead of the Requery action. The method is significantly faster than the action.

When you use the Requery action, Microsoft Access closes the query and reloads it from the database. When you use the Requery method, Microsoft Access reruns the query without closing and reloading it.

For more information, visit Microsoft's page Requery Method [Access 2003 VBA Language Refernce]

This tip and more can be detected by Total Access Analyzer! Try the free trial download of Total Access Analyzer today!