Alert when a value of a field is changed in a form

[psruthishali]

I have 2 fields in a form of which, if value of one field is changed, the other had to be changed. So, if value in one of the fields is changed, I want to display a message box saying that the other had to be changed. Can anyone tell me how to write a VBA script for this. Thanks in advance.

[MacroShadow]

In the after update event of the changed field put in the following:
MsgBox "The value of YourFirstField field changed." _
& vbCrLf & _
"You must change the value of YourSecondField field."

Check the help files for all msgbox options.