Timestamp error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I used the Help instructions in Access to create a field (macro) that
records the date and time a record is changed - and it worked. However, if I
don't hit the Enter key on my keyboard (and this will bring me to another
record), it will give me a error and will not record the changes or date/time
they were made.
In place of hitting the Enter key, I would like to create a button that says
"update" or "complete", and click on it when I am done with the changes in
the record, and have the date/time field record the change.
Can someone help please?
Thanks
 
Why don't you just insert the code to update the timestamp into the records
BEFORE UPDATE event? I believe that is the common way to handle this.
 
Back
Top