Did you try on the on got focus event Jim
R Rob Jul 31, 2003 #2 Thank's for making me re-think the GotFocus event. I got what I needed with a little tweaking.
B Bruce M. Thompson Jul 31, 2003 #3 There is also an "OldValue" property for the field that is available until the *record* is saved to the table. You just need to check for Null in your code in the event it is a new record or the field had never before contained a value.
There is also an "OldValue" property for the field that is available until the *record* is saved to the table. You just need to check for Null in your code in the event it is a new record or the field had never before contained a value.
