Adding an automatic datestamp to a record

P

Paul M

In my form I have a date field called "updated". I want to automatically
update this field with the current date whenever any of the data in that
record changes. Can someone explain how to set up the properties to do this.
I think I use the "After Update" property in the form but I can't get it to
work. Thanks in advance.

-Paul
 
O

Ofer

Add the DateField To the form, if didn't already do that.
On the before update event of the form add the code

Me.DateFieldName = Date()

The problem with this code, if a user change the data in one of the fields,
and then change it back to the prev value, the before update event will still
run
 
Top