In a recent Word front end app to an Access DB, I just let it go that if
they made any moves in any field on the form, I assumed they made some
change to the data. So I used the change event and then set a global
variable that the data was change. That adds the word CHANGED! to the
titlebar of the dialog to draw attention so the user knows they did
something, in case it was a mistake, but then I also asked...before they
bailed on the dlg...whether they wanted to save the changes.
This way I captured the fact that something change, but left it up to the
user to decipher if the change was something they wanted to commit to the
DB. If they clicked yes on the Q msg...it would pass the data. Otherwise it
would just continue on without saving.