Adding ADO records to collection

[VBWizInTraining]

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

[rickm]

Originally posted by VBWizInTraining
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

Why dont you try the filter method, and leave them in your recordset??

adoRecSet.Filter = "A = ? and B = ?"
adoRecSet.ReQuery