Add record to table when field is modified

[TKT_BEER]

I have this shortage report that the buyers every now and then change the dock date on parts.. I want to add a field that counts the times this date field has been modified... not in a form but directly in the table.. any ideas people?

 

[mdmilner]

My very first thought is to lock them out of the tables.
You could start using the built in Access security to do this and force them to use a Form where it would be rather easy to log changes using a number of field events such as _beforeupdate

Sorry that's not more useful. Could be I'm about to learn something too if somebody has a method.

Mike

 

[TKT_BEER]

I try to do something with the table last night just to find out that I couldnt do it!!! (LOL).. anyway I will go with the form method

thx alot and SALUD!!!