Date last modified for a field

[jhicsupt]

I have a field "EETitle". I need to track the last date updated. How would
I do that? Thanks in advance.

 

[Al Campagna]

jhicsupt,

You'll need to add a Date/Time field to your table, (ex. EETitleDOLE).

Use the AfterUpdate event of EETitle to trigger the code...
Me.EETitle = Now()
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[jhicsupt]

So where is the modified date stored? If I use the Afterupdate in the
Me.EETitle field, how does it get to EETitleDOLE?

 

[Al Campagna]

jhicsupt,Include that field in the query behind the form.
Place that field on your form. In other words, a text control with a
ControlSource of EETitleDOLE.
That textControl is now "bound" to the EETitleDOLE field of your
table... and any value you give it will be stored in the table, in that
field.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."