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!
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.
Darren D.
All Our Microsoft Access Products