Form Timer

  • Thread starter Thread starter Lonnie
  • Start date Start date
L

Lonnie

I am using a form to log calls, the form stays open till
the call is over, it would be good to keep track of how
long the call was. I have a start time already AND HAVE
TRIED ON EXIT AND AFTER UPDATE but they don't seem to
work. Can anyone help. Thanks in advance.
 
You would need to use BEFORE UPDATE. AFTER UPDATE fires after the record
has been written.

You would need code in your BEWFORE UPDATE event that will put the current
time in the "call ended" field or similar.

If your record includes a "call started" and a "call ended" then you can
calculate duration in your queries, reports, and forms.
 
Back
Top