Where to place message box code

[mitchem1]

In the Before Update event of my form, I have placed code that asks the user if they are sure they want to save their changes. I have recently added a subform. Now when the user tries to tab from the form to the subform, the message box appears. I am not sure how to get around this. I would like the message box to display any time a user tries to save changes to an existing record in the form or subform.

 

[Rich]

Data in the main form is saved as soon as you start entering data in the sub, you then have to delete the main form record if you don't want to save it or use unbound forms.