felliti: I assume you have a table with several fields,
one of which is a date. For one or more of those fields,
you would like Access to enter the current date whenever
a change is made to one of those fields. If you have only
one field for which you want to collect the amend date,
the task is easy. If you have more than one field, you
should have a separate date field for each field of
interest.
If you use a form to edit your data, for each textbox
representing each field, there is an event called "On
Change". Use this event to change the date in the date
field to current date when ever the data are changed. To
answer your question, "yes", but there are several other
questions of data integrity and data access that should
be addressed before you put the lock on this one.
Ray
