DAO 3.5 supports issuing multiple SELECTs in a signal statement. This example shows how to get each of the returned Recordsets.
See How to Build the DAO Method Samples.
On the MSDN Library discIf you have installed the DAO SDK, see Samples\dbdaoInstallDirectory\DAOSDK\SAMPLES\NextRecordset.cpp.