I have developed an application using Microsoft Access 2010 with the 'Document Window Option' set to 'Tabbed Documents'. Most of the time while the application is running multiple forms are up. If a user starts to make a change to a record on one form, I would like to force them to either undo or complete that update before moving to another form. There are a number of validations and additional updates that are triggered when an update on one form is completed. I do not want the application/database left in an ambiguous state.
So far the best I can do is add a Form.Deactivate event to each of my forms and perform an Undo if the form is dirty. I'm sure the users will not be entirely happy with this. Is there a way to either lock out all of the other forms or cancel the deactivate event if the form is dirty?