Message Box

[Alex Motilal]

Dear friends,
I want a Message Box to appear with the following conditions.

If on a Form someone changes the already entered data, the Message Box should appear with a Caution Title (also with a symbol such as Critical) asking if to accept the change. Also the Message Box should contain OK button to accept the changes and a Abort or Cancel button to abort the changes.
I feel it should be associated with the On Change Event.
Please help.

Alex

[June7]

I have never used OnChange event. This event would trigger with each keystroke in the control. I use AfterUpdate.

Maybe like:

If Me.controlname.OldValue <> Me.controlname & "" Then
If MsgBox("Accept Change?", vbOKCancel + vbCritical, "Caution") = vbCancel Then Me.controlname = Me.controlname.OldValue
End If