How to automatically refresh a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darrell Childress - 30 Oct 2007 17:43 GMT

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

Reply to this Message

ruralguy - 30 Oct 2007 17:57 GMT

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.

>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
[quoted text clipped - 4 lines]
>Thanks for any help,
>Darrell

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message