Access 97 How to Duplicate data held on a Mainform with 2 Subforms
Posted on 1998-03-24
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.