copy a record from a table to another table

[vjb]

How do I copy a record with 200 or so fields to another table in code?

 

[Pat Hartman]

Use an append query with selection criteria and you won't need any code. If you insist on doing it in code, you'll need two recordsets opened. One that you read with a do until EOF loop and the second to use with the .addnew method to insert the rows selected from the other recordset.

 

[vjb]

Thank you! That was indeed a better way. Works great!