• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Working with Recordsets and ... > Navigating Recordsets with VBA

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 that rely on Recordsets for their data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint