Track when a record was modified

[AlienzDDS]

Does anyone know of a way to time stamp a record whenever it is modified at
the table level?

I know how to time stamp using a form event but I am trying to find a bug in
my system which is causing an unexpected change in the field value and I
can't find the event causing this. If I could time ( and user) stamp when
the record is changed this may help me narrow down the event causing the
problem.

Any ideas appreciated.

Thanks - Ali.

 

[Klatuu]

Sorry, programatically is the only way to do this.

 

[Tony Toews [MVP]]

I know how to time stamp using a form event but I am trying to find a bug in
my system which is causing an unexpected change in the field value and I
can't find the event causing this.

I'd be very skeptical that a "bug in the system is causing an
unexpected change in the field value". One thing I would suggest is
running a Find and Replace program against your code to see if that
field is being used somewhere unexpectedly. For example some kind of
lookup field on a form that is actually bound to a table.

http://www.granite.ab.ca/access/thirdparty.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/