[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

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.
0
MaryJane032498
Asked:
MaryJane032498
1 Solution
 
guillemsCommented:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now