Date

[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 !!

 

[Rick Brandt]

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 !!

In the BeforeUpdate event of the form...

Me![Date Updated] = Date()

(or if you want the time as well)

Me![Date Updated] = Now()