TImer Event not stopping

[Gina]

I want the TimerInterval to reach 1000 (1 second), Call RefDates and then
stop. I know I'm tired so be gentle as to why this is not working.

If Me.TimerInterval = 1000 Then
Call RefDates
Else
Me.TimerInterval = 0
End If

Thanks guys!

 

[Rick Brandt]

I want the TimerInterval to reach 1000 (1 second), Call RefDates and then
stop. I know I'm tired so be gentle as to why this is not working.

If Me.TimerInterval = 1000 Then
Call RefDates
Else
Me.TimerInterval = 0
End If

Just set it to 1000 and then have two lines.

Call RefDates
Me.TimerInterval = 0

 

[Gina]

Rick... not working the Call RefDates not executing. (Heh, that's 50/50 not
bad)

 

[Rick Brandt]

Rick... not working the Call RefDates not executing. (Heh, that's 50/50 not
bad)

Have you tried putting in a break-point and stepping through the code manually?
I can't see any reason why the call statement would not run.

 

[Gina]

My mistake it's running but too fast perhaps I should explain... the form
opens you click the tab page (by then the code has run). I guess what I
want to do is loop it and run for 1 second pause and run when the tab page
is selected again. I think I may have to revisit this tomorrow because I
know I should be to stop and start this Timer but I can either keep it
running or stop it from running. Or as your code suggestion does run it for
a short period of time.

 

[Gina]

Oops.. that 2 out of 2

Have you tried putting in a break-point and stepping through the code manually?
I can't see any reason why the call statement would not run.