A Recordsets collection contains all open CdbRecordset objects in a CdbDatabase object.
Remarks
When you use DAO objects, you manipulate data almost entirely using CdbRecordset objects.
A new CdbRecordset object is automatically added to the Recordsets collection when you open the CdbRecordset object, and is automatically removed when you close it.
You can create as many CdbRecordset object variables as needed. Different CdbRecordset objects can access the same tables, queries, and fields without conflicting.
To refer to a CdbRecordset object in a collection by its ordinal number or by its Name property setting, use either of the following syntax forms:
Recordsets[0]
Recordsets["name"]
Note You can open a CdbRecordset object from the same data source or database more than once, creating duplicate names in the Recordsets collection. You should assign CdbRecordset objects to object variables and refer to them by variable name.