Recordset Copying/Cloning

[StormbringerX]

Is there a simple way to clone/copy a recordset? I'm creating a rather large one initially (at form_load), but I would like to duplicate it and use the duplicate for searches, etc... without disturbing the bookmarks on the original. Or is this even a feasible solution?
Thanks
Dave

 

[culshaja]

Try:

set rs2 = rs1.Clone

This will only work in ADO.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305