VC++

I have to use two recordsets in my VC++ ODBC project using CRecordset and CRecordView classes. I am able to choose only one recordset at a time to switch over to the other one I have to exit from the aplication and start over and choose the other recordset. I want to be able to switch between the recordsets while I am in the application.
Please help me.