Solved

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

Posted on 1998-03-24
1
261 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

813 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

12 Experts available now in Live!

Get 1:1 Help Now