Resetting the Form's timer

[AlanKW]

I have a form that shows all open "Cases" in 3 tables. The tables are getting large (can't archive right now) and therefore the on-timer refreshes take a few seconds every 5 minutes. To those that man the phones and are constantly typing, these few seconds wreck havoc when typing in their mainframe stuff.

My solution is to make it a manual refresh (requery). So that way the CSRs can click on refresh when they have a second, coming back from break, etc.. But because I want a failsafe, I still want to do an auto refresh every hour, BUT not if they've hit the button. Is there a simple way to reset the timer when they hit the refresh button?

Thanks in Advance
-alan

 

[luceze]

Alan,

In the on click event of your refresh button use this code:

me.timerinterval=0
me.timerinterval=60000

This will start the timer over.

HTH
Eric

 

[AlanKW]

I had read that on here somewhere, and I'm fairly certain that I tried it before posting, but as I try it again, it appears to be working.

Thanks!