Unanswered: Confirmation before update, restore if canceled
I have a singe form where the user can alter some fields. Now, when he closes the form, or moves to another record I want a msgbox to display to ask his confirmation of the update. If he cancels, I want the original field value to be filled in.
The confirmation box appears. If he chooses OK then the new values are saved. If he chooses CANCEL, he returns to the current record, but still with his newly typed in values. So actually, he cannot leave the record, unless he enters 'ESCAPE'. I thought the above macro would do the work, but it doesn't!