how do i copy a recordset?

[chevyv8]

Please help, I have some complete recordsets in a table that I want to copy into another table, once I have found the recordset how can I copy it? Is there a command like:

RecordSet (OP_rec) = RecordSet (IP_rec)
OP_rec.Update

If so could I do a batch of recordsets without a loop as well?

Any answers most welcome

 

[rookery]

Hi

You could use some SQL like:

Set db = CurrentDB
db.Execute ("SELECT * INTO [tblNew] FROM [tblOld]&quot
db.TableDefs.Refresh

This would copy all the contents from one table to another.

Let us know how you get on!

NSS

 

[chevyv8]

Sorted, thanks for your help