Printable View
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??Quote:
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
adoRecSet.Filter = "A = ? and B = ?"
adoRecSet.ReQuery