Originally Posted by
aytee111
Do you have a timer event running in the background?
Yes, I do have a timer that can be set to start from 30 to 900 seconds. And I set the countdown text box to: Me.txtTimeLeft.SetFocus.
This is what I have:
Code:
Private Sub Form_Timer()
timer = timer - 1 'countdown
If timer > -1 Then Me.txtTimeLeft.Value = timer 'show the time in the textbox
If timer = 0 Then
'......put event here
TimerInterval = 0 'stop the timer
DoCmd.Beep
MsgBox "time is up"
End If
End Sub
Thanks.