Create a recordset from a recordset

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
 
V

Van T. Dinh

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

recordset vs collection 2
Determine position in query recordset 1
query a recordset 2
Changing pivot table ADO recordset 0
Temporary recordsets 3
A theoretical question: how best to manage perpetual recordset needs? 24
How to Retrieve Data From Another Access Dataase Without Linking to It? 3
Recordset automatically updates 2

Top