Automatically update the date in a field

sychoangel

Registered User.
Local time
Today, 14:16
Joined
Jul 4, 2008
Messages
20
I have a field that has the date the record was created, how can I get this date to update to the current date every time the record is updated.

It is initially being populated by the fields default value being set to "=Now()" when the entry is firt being created.
 
In the after update event of the form where users would update it, try

Me.ControlName = Now()
 
Thankyou!

That worked perfectly! Very simple :)
 

Users who are viewing this thread

Back
Top Bottom