Solved

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

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

912 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

20 Experts available now in Live!

Get 1:1 Help Now