I have a database which has a main form and a subform. Each record on the main form can have several subform records attached to it. Is it possible to have a command button which will allow copying and pasting of the subform record, as all the information could be the same bar one field? I hope this makes sense.

Thanks for any help.

If you select a new record in the subform and press Ctrl + ' it will replicate the data from the previous record.
Hope this helps
Jerry Dixon

Thanks very much. That seems to work fine.

Rothron