Auto date when data entered?

J

JR

We are updating a database for instructors to enter the percentage of
course work that a student has completed. In the past instructors were
notorious for not adding the date the entry was made. We'd like to be
able to have the date field automatically update when ever the percent
information is edited. Any ideas?
JR
 
L

Larry Linson

JR said:
We are updating a database for instructors to enter the percentage of
course work that a student has completed. In the past instructors were
notorious for not adding the date the entry was made. We'd like to be able
to have the date field automatically update when ever the percent
information is edited. Any ideas?
Click to expand...

Add a DateUpdated Field to the Table. In the BeforeUpdate event of the
Form, set it to:

Me.DateUpdated = Now()

That will store both Date and Time.

Larry Linson
Microsoft Office Access MVP
 
Top