Last Modified Field

[Jason Wills]

I Have posted this before, but i seem to have lost the thread, so sorry.

i'm after a way to have a field display the date, and to be automatically
changed if any data on that form is altered....

Please Help.......

 

[JohnFol]

On the BeforeUpdate of the form just do a

me!DateField = now()

 

[Jason Wills]

unfortunatley, this wouldn't work. i have other things on my form that would
trigger a beforeupdate event on the form, any other ideas?

 

[Alex White MCDBA MCSE]

Hi Jason,

Then surely this will do what you want, e.g. when any data is changed on the
form update the date/time, if you are trying to log when specific fields are
updated then look at the on change events for the specific textboxes.