Solved

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

Posted on 1998-03-24
1
254 Views
Last Modified: 2012-06-21
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
Comment
Question by:MaryJane032498
1 Comment
 
LVL 3

Accepted Solution

by:
guillems earned 100 total points
ID: 1971645
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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now