Opening Multiple recordsets at the same time

How can one use multiple recordset in ADO application. I would like to open two or three of the recordsets at the same time.
I would appreciate very much If someone has got a code to offer me. Counting on your co-operation. Thanks.

Albert

[Gil Ben-Yosef]

There is no problem at all.
If you know how to open one ado recordset then you know how to open multiple recordset.
Just give anyone of them a different name.

[tmc]

I usually set up multiple recordsets in the Data Environment. If you query MSDN on DataEnvironment, you should get a pretty clear explaination of how this is done. Not much coding, just careful clicking.

Good luck.


------------------
Thomas