O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required