Need help with timer function

Hello,

I have a form that uses a timer function to track the duration of a phone call.

in the OnLoad event of the form I have:

 Private Sub Form_Load()
Select Case MsgBox("Start Call Timer?", vbYesNo)
  Case vbYes
    If Me.TimerInterval = 0 Then
      StartTickCount = GetTickCount()
      Me.TimerInterval = 15
      Else
     
      TotalElapsedMilliSec = TotalElapsedMilliSec + _
         (GetTickCount() - StartTickCount)
      Me.TimerInterval = 0
  End If
 
  Case vbNo
   
  Case Else
    End
End Select
End Sub

This starts the timer when the form is loaded, however, If the user opens the form again, it resets the count. The textbox that displays the time is bound to a table in the back-end and is saving appropriately. Is there a way I can make the timer pick up where it left off?

Thanks!Start Free Trial