VBA Copy

[DebSabre]

I have several fields in a recordset and I copy each one individually. Is there a way in VB to copy one recordset to another.

Example:
rstblSingle![intCourtID] = rsCourtTbl![intCourtID]
rstblSingle![intCaseID] = rsCourtTbl![intCaseID]
rstblSingle![strDestination] = rsCourtTbl![strDestination]

This example shows three fields being copied. There are many more fields.

Is there a wildcard like: rstblSingle[*] = rsCourtTbl[*] ????

I could not find anything. I really appreciate all the help I have gotten in this forum. Thanks.

 

[KenHigg]

Can you just run a query instead of doing ado?

???
kh

 

[DebSabre]

Reply to KenHigg

I am using the VBA to eliminate records with duplicate dates,times,destinations,.... I have a one to many join on two tables, but in this instance I don't want to see the duplicates. So I am copying 23 fields from one table to another. I thought there may be something more efficient.