Can you open an ADO recordset based on another ADO recordset? If so, how?
Printable View
Can you open an ADO recordset based on another ADO recordset? If so, how?
You can set the new recordset to the old recordset using
Set NewRS = OldRs
This will mean that any changes to one are reflected in the other.
You can also use
Set NewRs = OldRS.Clone
This will give you an independent recorset