duplicate records

A

Ash

I have a main form with 3 subforms. The main form is a single form and the
subforms are continuous forms. On the continuous forms, I can have many
records pertaining to the one on the main form. I would like to create a
duplicate of the record on the main form and the records of the subforms.
The primary key on the main form is an autonumber, and the primary key on the
other subforms are number. How can I create the duplicates on the subform
and have the ID be the current ID?

Any help is appreciated.

Thanks.
Ash
 
Top