Parent form field AfterUpdate - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Parent form field AfterUpdate

William Dowler

3 years ago

I have a subform (frmSubOrderService) that collects different types of Service data. I show totals on the Header section of the Parent form (frmSubProject). When the subform field is updated, I need to update certain fields on the parent form. How do I force the field on the Parent form to fire the afterupdate event. Updating the Parent field with a value works fine but doesn't fire the event.

	Sami Shamma @Reply 3 years ago
William First, make the code in the afterupdate a Public sub so you are not calling the after update directly, let's call it "UpdateFields". then from the frmSubOrderService make the call to the UpdateFields as follows: Form_frmSubProject.UpdateFields Good luck

	William Dowler OP @Reply 3 years ago
Sami, I'm embarrassed to tell you how many different ways I have tried to accomplish this. Your solution worked like a charm. Many, many thanks.....

	Sami Shamma @Reply 3 years ago
You're most welcome I think it was one of the Kevin's who helped me with this problem few months back. Just paying it forward.

	William Dowler OP @Reply 2 years ago
Sami, That's the beauty of this forum. We have so many people who are willing to help one another.

	Sami Shamma @Reply 2 years ago
That is so true. Happy new year William

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

Next Unseen

New Feature: Comment Live View