Confirm Record Changes

[Aaron]

In the tools/options I have "confirm record changes"
checked. I was assuming that this meant before I move to
a new record or close database it would ask me if I want
to save the record but it doesn't. However - I would like
it to! Basically I don't know much about any code type of
things in access, just basic stuff. Can someone help me
to get it to ask to save before closing? Thanks!

 

[Van T. Dinh]

Actually, you don't need to check the Controls' Values against the
corresponding OldValues. Something must have been changed (i.e. the Form is
dirtied and there are change(s) to be saved) for the BeforeUpdate Event to
occur.

If nothing has been changed (i.e. no need to save), the Form_BeforeUpdate
Event doesn't fire.