Different Queries with Recordset

[Miguel]

I'm working with a Data Base and I'm using ADOR recordset.

I would like to know if after to open the recordset with the following parameter
(rs_pp.Open “Select * from my_table”, “my_BD”)
I can to make another query without to close the recordset.

Can I make different queries into the same table with the same recorset?. The queries, logically, would be in different time.
If this subject is possible how can I make it?

Thanks for your help......

[danbars]

a recordset object IS the records you get from a query. the only way u can use the same object for few recordsets, is to use:
set rs_pp=new ador.recordset
everytime before u call '.open'