Update time field on edit

B

Ben

Hi,
I was wondering if it was possible to include a date in my form which
displays the date the record was last updated. I have no trouble doing this
on the 'before update' event, but I would like the date to update on the
current view. At the moment the update can only be done if I press F9 or go
forward one record, then back. Can the date change as soon as I begin to
alter data??
Cheers,
-Ben
 
R

Rick B

You could, but what if the user hits ESC? The proper way to set a timestamp
would be to do it AS you save the changes.
 
B

BLTibbs

If you create a macro that updates the date in that control, then put that
macro on all of the controls in the form for the key is pressed down event,
that should update your time. You may also need to include the repaint
command in your macro.
 
Top