Verify no Changes in Sub-Form before next record

[gopherking]

I have a form with a subform in it where users make necessary updates to fields as they need to. I have a Save and Cancel button where necessary so that users can save the changes they make to the record as they go along, but they don't always remember to click one or the other. I am trying to add in some code to check to see if any changes have been made on the Sub-Form before the user can go to the next record in the main form. By the way, the main only displays a single record at a time.

Currently, I have tried to place some code in the On Exit and Lost Focus events for the Mainform, but they don't bring up any of the msgbox's I have in the code. Is there a specific event that would be best for this?

[boblarson]

Forms automatically save when you move between the parent form and subform as well as moving to a new record within the same form.

So, you would need to use the subform's BEFORE UPDATE property to check for any changes and that will fire if you are in the subform and then click something on the main form.

[gopherking]

Thanks Bob, adding it to the Before Update worked, but I have run into other issues with my code that I didn't encounter before since it wasn't being called correctly. Unfortunately, I need to drop this issue to resolve some others right now and won't be able to look into it for some time. Thanks again for the response!