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.
If you have installed the DAO SDK, see InstallDirectory\DAOSDK\SAMPLES\NextRecordset.cpp.