Code to Mark Record w/Date Data Changes

[jtvcs]

Does anyone have the code for marking a field like "Date Updated" with today's date ONLY IF DATA HAS CHANGED on that record's input via a form ? Any suggestions greatly appreciated. Access 97 version. Thanks. JT

 

[Tiro Cupidus]

I think you can use the OnChange event of the form's controls to set the date field = now().

 

[Mile-O]

Use the form's BeforeUpdate event to run the APPEND query as this event is only triggered if changes have been made.

 

[jtvcs]

Thanks Mile-O-Phile, your idea worked great. JT