Multiple instances of one recordset

[shu745]

Hi All,

Does anyone know how to create multiple instances of the same recordset? For instance, I'm looping through rs1 and in that loop I would like to use the same recordset but a different filter. When I try assigning 'Set rs2 = rs1' I think it still points to rs1 and affects my looping. Is there any way to create multiple instances of the same object without having to create a new recordset each time?

Much thanks for any assistance!

 

[Bob2]

Is there any specific reason why you can't create another recordset?


Regards

M

 

[thall89553]

I am developing a site which uses several recordsets, from the same table. From previous post I have made, it is not such a big hinderance on performance as long as you use the same connection.

 

[shaddow]

You can use Clone method of the recordset

Set objRecordsetClone = objRecordset.Clone

http://www.devguru.com/Technologies/ado/quickref/recordset_clone.html

________
George, M