Create a recordset from a recordset

  • Thread starter Thread starter Gerry Goldberg
  • Start date Start date
G

Gerry Goldberg

How can I create a recordset from another recordset? The first recordset was
created in VBA with code:
set rst1=dbs.openrecordset(myQry1)
I would like to create a second recordset that is based on the first
recordset. Is it possible to do this?

Thanks,

Gerry Goldberg
 
If you are talking about a filtered Recordset based on the first Recordset,
then check Access VB Help on the Filter Property of a Recordset Object (both
DAO and ADO).
 
Back
Top