When I use a form to edit records, I want to create a
field that automatically records the date and time each
time a particular field (not the record)is modified.

PLEASE and Thank you!

Suppose you have a twitchy user who opens a form, and makes a change
to a text field, backspaces, types again, backspaces, types again,
backspaces, types again, mouseclicks, types over...

Do you want to record each and every keystroke? If so, use the
control's Change event and append a record to a changes table with
Now() being loaded to a date/time field. This table will get very,
very big very, very quickly and - IMHO - will be of VERY little use.

A less drastic version would use the control's AfterUpdate event. If
the user changes a field, moves off it, moves back to the field and
changes it again, this will write each completed change.

Note that a field is not actually changed in the table until the
record is saved. Changes made on a form that don't get saved have NO
effect on the database, and I fail to see any point in tracking them!

                  John W. Vinson[MVP]    
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public