Which event(s) should be used to capture changes
Please help me on the following:
The value shown in a field of a subform is bounded with a table column (not primary key). After the value is changed on the subform, I need to give a warning message based on the difference of the two strings. Which event should be used here to capture both the old and new values? I tried to use After Update Event and got the new value.
Thanks in advance,