Access 97 How to Duplicate data held on a Mainform with 2 Subforms

I have a mainform that contains 2 subforms.   The mainforms recordsource is based on 1 table.  Subform1’s recordsource is based on another table.  Subform2’s recordsource is based on a query (between 2 other tables).

I want to add a button that will duplicate the mainform and subform1 and subform2 details.  So far, I have been able to duplicate the mainform and subform1 details.  To do this, I have (a) written an event procedure to set the mainforms tag property to the currently selected  mainform_ID and have used “recordsetclone” to copy the mainform’s recordset; and (b) created an append query for subform1 details (which basically appends a copy of subform1’s recordset into the attached table). However, I also need to be able to duplicate details held in subform2.

Does anyone know how to duplicate mainform, subform1 and subform2 details.
MaryJane032498Asked:
Who is Participating?
 
guillemsConnect With a Mentor Commented:
Hi!

 I think if the subform2 is based in a query, and you add a register in the table1 and in the table2, the only thing that you do is a requery. (But for more information, I like to see , if it's possible your database)

My e-mail is:   guillems@i6.com
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.