Auto date

  • Thread starter Thread starter Sojaminc
  • Start date Start date
S

Sojaminc

I am trying to create a field in a form that if anything is changed on it, it
will automatically update the date to current date. Is this possible?
 
Sojaminc said:
I am trying to create a field in a form that if anything is changed on it, it
will automatically update the date to current date. Is this possible?
Click to expand...


Make sure the last changed date/time field is in the form's
record source table/query. Then use the form's BeforeUpdate
event:

Me.lastchanged = Now
 
Hi -

You can do this in the On Dirty event of the form, which fires as soon as you
make any change to any field on the form.

me![Mydatefield] = date()


John
 
Back
Top