Adding an automatic datestamp to a record

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

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


"Paul M" wrote:

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