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. samle4EE.accdb
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.