Auto Requery/Refresh

[Leesha]

Hi,

I have frmReports that I'm using as a dashbooard for a variety of information running off the server. Presently when I want to refresh the info I click a button that runs code to requery the various info. Is there code that will automatically requery the form say every 15 minutes?

Thanks,
Leesha

[HansV]

You could set the TimerInterval property of the form (on the Event tab of the Properties window) to 900000 (milliseconds; 15 minutes = 900 seconds = 900,000 milliseconds), and write code in the On Timer event of the form to requery (you can use the same code as in the On Click event of the command button).

[Leesha]

If frmReports has a tab control on it, each of which contains forms, will setting the on timer event for frmReports requery everything on the form or should I set this for each of the subforms as well?
Thanks!
Leesha

[HansV]

You could requery/refresh the subforms from the On Timer event of the main form. You don't have to create an On Timer event procedure for each subform.