Date

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

Guest

I am a little new to Access.

I have a form and on that form I have a field called "Date Updated". I will
like this field "auto populated" with the system date when the user updates
the record they are on.

Can someone help?

Thanks !!
 
Ty said:
I am a little new to Access.

I have a form and on that form I have a field called "Date Updated".
I will like this field "auto populated" with the system date when the
user updates the record they are on.

Can someone help?

Thanks !!
Click to expand...

In the BeforeUpdate event of the form...

Me![Date Updated] = Date()

(or if you want the time as well)

Me![Date Updated] = Now()
 
Back
Top