date last updated field

[utiltree]

I have created a field for the date the record was last
edited/updated. How do I get it to automatically enter
the current date when you do something to the record?
Would I create an expression?? Am I supposed to do it in
the table or the field?? ANY help would be greatly
appreciated!!
Thanks,
Kari

 

[AJ Raiber]

Kari -

Assuming that you are using a form to make input into
the table, input the following code in the AfterUpdate
block of your fields:

me.dtUpdate.value = Date

This will cause the date ton the field to change anytime
you update a field on the form. This could be cumbersome
however, if you are changing many fields in a record at
one time. However, if this is a one field update this
will do the job. HTH

AJ

 

[Gary Miller]

Actually, if you put it in the AfterUpdate event of the Form
itself, you will only have to do it once.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________