Copy A Record

[Guest]

I have a form with a subform. I want to copy information in the main form
(at the top) from a previous record.

When I create a command button using the wizard to duplicate a record, all I
get is a blank record as if I clicked on New Record.

I was hoping to get a copied record generating a new ID and the subform
should be blank ready to key in new data.

Is there something I'm doing wrong or can you not copy a record that has a
subform?

Thanks!

JS

 

[Guest]

That duplicate record button is copying the record, adding a new record, and
pasting it. Since you have a subform, it will not work. I think that you
should create your own. You can do this by running a query that inserts a new
record into the main table exactly like your current record. Then you need to
have the form search for that record. I believe that this should work fine.

If you need any assistance on these pieces that I have lined up, please let
me know.

 

[Allen Browne]

There's some sample code here that duplicates the main form record and the
subform records:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html

Just ignore the part about duplicating the subform records.