Subform dirty state not calling main form's beforeupdate event

[Peter S.]

In my Access form in the beforeupdate event, I post a question if the user is
sure they want to save their changes. However I added a control tab that has
a subform that is associated with a different table and noticed if the user
makes changes in the subform the main forms beforeupdate event never gets
kicked off.

Is there a way I can get access to hit the main form's beforeupdate event if
changes are made in a subform and the user closes the main form? Any thoughts

 

[ruralguy via AccessMonster.com]

SubForms have their own BeforeUpdate event. In case you didn't know, a bound
MainForm will try to save a Dirty record when you move the focus to a
SubForm; and a bound SubForm will try save a Dirty record when you move the
focus back to the MainForm.