Duplicate Record

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

Guest

Hello

I have a button duplicate record which works great,but it does not duplicate
any data on the subforms.

Any Ideas !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
See:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html

The article suggests duplicating the main form record in the RecordsetClone
of the form. This gives you the new primary key value, and you use use that
in an Append query statement to duplicate the related records as well.

If you have multiple related tables (so multiple subforms), you will execute
multiple append query statements.
 
Hi Allen, I am having a similar problem with my Main/Sub form. What's
happening is the information I enter in my forms are treated as two different
recordset in my table. This should not happen, and wondered if you could
shed light on it.
Thanks Allen, I appreciate any help you can.
 
Back
Top