Auto date

[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?

 

[Marshall Barton]

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?

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

 

[J_Goddard via AccessMonster.com]

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