Stored previous field value before updates

Taurus05

Registered User.
Local time
Yesterday, 22:51
Joined
Mar 29, 2005
Messages
31
Hi,

How do I stored a previous value of a field when the record updates (e.g. Date delivered changed from 01-April-07 to 01 May 07) in a form.
I would like to prompt the user after change like "Your Date has been changed from 01-April-07 to 01 May 07" after pressing the enter key or tab key on the screen.

Thanks.
 
Try OldValue property. It's in Access help.

Col
 

Users who are viewing this thread

Back
Top Bottom