troubleshooting Question

Problems with recordsetClone

Avatar of Rich
RichFlag for United States of America asked on
Microsoft Access
5 Comments1 Solution596 ViewsLast Modified:
I am having an issue when I am using RecordsetClone object to create a new record and then display it on a form. The issue is that even though the RecordsetClone object gets correctly filled in with data from a previous form in the current form onLoad event method, and the resulting record is stored in the database, when the new form is display, incorrect record data is displayed.

I am attaching a sample Access 2010 database.

Use the frmNavigation to start, and then open a Quote - this is frmQuote. At the bottom of the Quote is a button that says "Create Booking". This button opens the frmBooking form and runs code to create RecordsetClones of the data. Data is taken from a main table quotes and two subform tables quoteBilling and quoteMerchandise.
The new form is a view of the Booking table and the Quote and subtables are copied to the corresponding Booking and bookingBilling and bookingMerchandise tables. This new record should then be displayed on the frmBooking. The problem is that the data displayed on the frmBooking form is from an incorrect record, not the one just created.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros