Please help with duplicate recods (form, subform) code

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

Guest

Hi,
Please help me... I need to duplicate a record (parent form
based on table Jobs) link to the subform (based on table Samples) by "JobID".
Relation is 1=M.
Many times we need to duplicate the job with the samples and modify some
information (date, labid, etc).

Do you have or can provide an example on how to accomplish this?
When we need to duplicate only the job, a copy record was fine, but
duplicating the record AND the many samples linked to it by the JobID is
getting more complicated.

Thanks in advance. Looking forward to lear something new today!
 
How do you get the new JobID after copying the main records?

After the copy if you have the new Id number and the old id number you can
run an insert query, to append all the records with the old id number to the
new one.
 
Back
Top