Skip requery when tab is not active during timer function
Posted on 2011-04-20
I have a mult-tab form. Each tab contains a form that queries different sets of data. Each form is set to requery every 5 seconds (on timer me.requery, timerinterval = 5000). There is a some overhead associated with each of these requery operations. I would like to only requery the tab that is currently active (on top) and skip the requery if the tab is not active (since it can't be seen).
Is there some way to determine what tab is active from these forms on the tabs?
If so, I can skip the requery if the tab is not active (on top).
Any help will be greatly appreciated.