I'm trying to do one of two things. I'm working with a recordset returned by a SQL stored procedure, and as I apply my complex criteria in the next step, I want to store the records I want to keep in a collection.

My problem is that I cannot seem to say :
adoRecord.open adoRecSet

and when I try to do:
objCollection.add adoRecSet

the record loses focus as soon as the recordset it came from is closed.

Can't proceed without some assistance...

Very grateful for your help.
-Sabrina