On Timer Event, execute only Once

[mikejaytlabustro]

Hello access-programmers!

Got a problem here:

Timer Interval = 5 Seconds

Private Sub Form_Timer()

My code here..

End Sub

The code repeats every 5 seconds, what I want to do is to execute it only once.
I have no idea how to solve this one..

Thank you in advance!

 

[pbaldy]

Try setting the timer interval to 0 at the end of your code.

 

[mikejaytlabustro]

Great! Thanks to you pbaldy


Private Sub Form_Timer()

My code here..
Me.TimerInterval=0

End Sub

 

[pbaldy]

Happy to help!