This concerns an Access 2002 (XP) database. There are two fields,
"Notes" (Memo Field) and "Notes Update" on a form (among others)
which I am concerned with here.
Problem: I need to be able to tell when people have added notes to a
record. (this database contains 6000+ records)
I want to set it up so that "Notes Update" is updated to the current
date whenever someone actually enters data into, or modifies data in,
the "Notes" field (but NOT when just browsing the information in the
field).
How I tried to solve the problem:
I added a field called "Notes Update" in a date format to the table.
I wrote a macro and put it into the "After Update" field of the
"Notes" Field on the form. The macro simply jumped to the "Notes
Update" field.
I put =Date() in the "On enter" property of the "Notes Update" field
on the form.
My hope was that an entry in the "Notes" field would trigger a jump to
the "Notes Update" field, which would then cause Date() to put that
day's date into the field.
I also removed the tab stop from the "Notes Update" field to prevent
anyone tabbing to the field and changing the date that way.
Unfortunately it didn't work.
Can anyone suggest the best way to get this to happen?