Last update table / log

[rowbro]

Good day,

I am trying to create a way to capture/report the last date that a certain field in a table in my database was updated with a certain value (from a defined list in another table). Is there some way to do this?

Thanks in advance,

 

[alansidman]

Look at this link. You should be able to modify this to meet your needs.

http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm