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,

lxu

The Before Update event should get the value before the changes are made. Have you tried that?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks. It works.