Auto Date on changes

[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

 

[Rick Brandt]

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

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.

 

[Joan Wild]

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()