How do I setup a Last_Update field on a form?

[Guest]

Any time I change any field on my form I'd like a Last_Update field to be
populated with the current date and time before moving to the next record or
after a click a SAVE RECORD button I have on the form.

 

[Rick Brandt]

Any time I change any field on my form I'd like a Last_Update field to be
populated with the current date and time before moving to the next record or
after a click a SAVE RECORD button I have on the form.

In the BeforeUpdate event for the form...

Me.Last_Update = Date()
or
Me.Last_Update = Now()

(depending on whether you want just the date or the date and time)