Time Stamp

D

Douglas J. Steele

You can only do this if you do your updates through a form, as opposed to
directly in the table.

Add a LastUpdated Date field to your table. Add a text box on your form
that's bound to that field. (There's no need to make the text box visible).
In your form's BeforeUpdate event, set the value of the text box equal to
Date() if all you want is the update date, or Now() if you want both date
and time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top