Automatically update the date in a field (1 Viewer)

sychoangel

Registered User.
Local time
Today, 12:02
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.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 12:02
Joined
Aug 30, 2003
Messages
36,140
In the after update event of the form where users would update it, try

Me.ControlName = Now()
 

sychoangel

Registered User.
Local time
Today, 12:02
Joined
Jul 4, 2008
Messages
20
Thankyou!

That worked perfectly! Very simple :)
 

Users who are viewing this thread

Top Bottom