Commit Parent and Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Commit Parent and Subform

Mark Fannin

14 months ago

I have a form with two subforms. Currently, after entering some info, when I click out of the subform it automatically commits the data to update the table. QUESTION: Is there a way I can fill out the form & subform, and then click a save button to commit the data from both at the same time? Rationale: I want to review the data before I save the form (which contains two subforms). Thanks for the benefit of your knowledge. :)

	Richard Rost @Reply 14 months ago
Not really, since I'm assuming your data is related. Hence the subforms. You would need to get an ID for the parent form before you can assign that ID into the subform. So, the only thing you could really do would be to commit the parent form record and mark it as temporary. Once the subform is committed, you could uncheck it as temporary.

	Mark Fannin OP @Reply 14 months ago
Many thanks! The database is coming along nicely and I've got you to thank for it. All the best to you and the great people who help others on your website.

	Richard Rost @Reply 14 months ago
It's mostly those guys. I couldn't do this without my moderators. I just jump in when I have a few free minutes.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View