copy record

[kingsgambit]

In access there is a wizard that lets you duplicate records, on my form I have a subform as well is it possible to duplicate both.
The main form contains customers details the subform contains a quote for a job, as jobs can be simular I wanted to copy the record so I could just change the odd item in the quote,then change the details of new customer

 

[HOTBETZ]

i dont know whether this would be the best method, but i would just use an append query and get it to pick the records straight off the form.

this would mean that u could merge both forms/tables into one.

 

[kingsgambit]

How would it produce a new record? and show in the form.
I have not used append query so I am not sure how it works