How to automatically refresh a form

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
How to always get the top level form reference, when calling from any subform/subform... 0
Need help on how to pass calculated field from a form to another form 0
Subform Refreshing! 1
Refresh 1
Form/Subform problem 8
Automatically populate a field based on 2 others 7
Refresh a form 3

Back
Top