Copy A Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top