Auto Date on changes

  • Thread starter Thread starter Frank Fitchner
  • Start date Start date
F

Frank Fitchner

I have a form with all the information coming from a Query..... What I am
trying to do is update the "date modied" field whenever something is changed
on the form.... I can't seem to get on update to work or anything to work
for that matter... Any help would be greatly appreciated....

Frank
 
Frank Fitchner said:
I have a form with all the information coming from a Query..... What I am
trying to do is update the "date modied" field whenever something is changed
on the form.... I can't seem to get on update to work or anything to work
for that matter... Any help would be greatly appreciated....
Click to expand...

In the BeforeUpdate event of the form have code similar to. . .

Me![date modified] = Now()
or
Me![date modified] = Date()

.. . .depending on whether you want the date and time or just the date.
 
In the BeforeUpdate event for the form set your date modified field to
either Date() or Now(). Date will store the date, while Now will store the
date and time.

Me![Date Modified] = Date()
 
Back
Top