Newly created Recordset objects containing multiple record sets will initially reference only the first record set. To gain access to the subsequent record sets, you must use the NextRecordset method to return a new Recordset object. The syntax for this method is:

Set NewRecordset = Recordset.NextRecordset (RecordsAffected)