How do I setup a Last_Update field on a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
GregsDragon said:
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.
Click to expand...

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