Copying records

[Dan]

I have an Orders table and an OrderDetails table. I want to select certain
orders, change a field or two, and make a copy of these records (along with a
copy of their detail records unchanged). I know how to OpenRecordset and loop
on the records selected and to get the fields within those records. Is there
an easier shortcut to copying records and their associated detail records?

 

[Allen Browne]

Using a recordset for the main record probably makes sense, because it's
easy to get the new AutoNumber value that you need for the new related
records. After that, you could execute an Append query statement.

Here's an example to follow:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html