date last updated field

  • Thread starter Thread starter utiltree
  • Start date Start date
U

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
 
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
 
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
________________________
 
Back
Top