Navigating Recordsets with VBA
Recordsets are the foundation for all Access data-related operations. The VCR-style navigation buttons of datasheets and bound forms manipulate the record pointer of the underlying Recordset. The following sections show how you emulate Access's navigation buttons with VBA code and use loops to automate processing of an entire Recordset.
Generating the Temporary Recordset
You often use temporary Recordsets for specific purposes, such as populating a list or combo box. When the Recordset operation completes, you close it, releasing its connection to the underlying table or query and freeing its memory resources. It's a common practice to create temporary Recordsets when opening a form that contains the unbound controls ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
