How to automatically refresh a form

D

Darrell Childress

I have a form which employees use to start and stop jobs they are
working on. This is a form they typically leave open most of the day. On
the form is a subform which shows the current "jobs in progress". How
can I automatically update that subform - say every 5 minutes?
I saw the TimerInterval property on the form's properties page, but the
"Help" info wasn't very helpful.
Thanks for any help,
Darrell
 
R

ruralguy via AccessMonster.com

The TimerInterval is the frequency you want the OnTimer event to occur in
Milliseconds. 300,000 would be 5 minutes. You could then simply requery the
SubForm in the OnTimer event.
 
Top