Saving the Date a Record was Last Edited
This will add the time and date that the record was amended to the table. Anther option is to include just adding the date, in which case you would use 'Date' instead of 'Now'. If you want to also show who amended the record last, then you need a way of getting the name of the user. If you have implemented Access security, then you can use the CurrentUser function to return the current user account. If you haven't done this, and your database is on a Windows NT system, then you should be able to use an API, such as GetUserNameA, as shown on The Access Web.
If you are interested in the date that the record was added to the table, then you replace the Before Update event with the Before Insert event:
Copyright & Disclaimer
Last modified at 06/06/2006 15:01:39