Access Time Stamp for Date of Modification

[Guest]

Hi,
I got a Access table where there is a time stamp field for a new reord
created. Now I want to add another field that would capture the date a
particular row was modifield. Is there any way in Access to keep track of
date of modification for a particular record. I need to have this feature to
know the latest date of modification for a particular record. Thanks for any
help.
Regards.

 

[Rick B]

Sure, just add code to your form to store the current date and time before
you commit any change. You could also include their UserID if you are
having them log on.

For details, read the previous posts on the topic. Search for "timestamp".

 

[Guest]

Thanks for your help Rick B. I am going to search and find out the solution.
Regards.