Unable Rolllback record update if subform get focus.

[Guest_imported]

I have a form, frm_Main. Whenever I update the field and do not touch the sub form data, I test .Dirty and prompt to save changes. If user clicks "No" to saving changes, then I run Save and Undo. That works the way I want it to.

However, If I update the Main form, then proceed into the subform, and then Exit. The record is saved with no prompt to save changes.

How can I get the prompt On_Exit_Click, if I have moved into the subform?

 

[JerryDennison]

When the focus shifts to the subform, the current mainform record is automatically saved. Where are you testing for .Dirty? It should probably be in the BeforeUpdate event procedure of the main form. That way, it should trigger when the focus is shifted to the subform.

 

[Guest_imported]

That should suffice, Thank you.

 

[JerryDennison]

You're welcome.