Duplicating records

[Guest]

I have a main form and 3 continuous subforms. The primary key on the main
form is an autonumber and the primary keys on the subforms are numbers. I
would like to create a duplicate record of the main form and the records in
the subforms. I have a button that the user can click and it should create a
duplicate record for the main form and the subforms. I am having trouble
creating duplicate records in the subforms. Any ideas are appreciated.

Thanks.
Ash

 

[Guest]

Link the Main form and the subforms by child and father properties.
When you add a new record in the main form it will get a new number been a
auto number, every time you add a new record to the sub form it will auto get
the number from the main from.