How refresh form every 5 minutes

I have a form which has several field calculations and would like the form to refresh itself every 5 minutes.  How do you do this?
SteveL13Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
use the OnTimer event of the form

set the TimeInterval property to 300000

Private Sub Form_Timer()
Me.Requery
'or
'Me.Refresh
End Sub
0
 
YohanFCommented:
On the form properties there is a property called "Timer Interval", this is in mili second so (5 min x 60 x 1000) set it to 300000.

There is an event called on timer and put your refresh code there. to refresh form its Me.Refresh

hope this helps.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.