Refreshing a form

[Ana]

Hello,
I have a form which displays a number of open claims. I would like this
number to refresh every...say 1 minute.
Now, I'm doing it manually by a refresh command.
Howto do it?
TIA
Ana
BTW...Great newsgroup!!!

 

[Douglas J Steele]

Forms have a built-in timer control.

In the Load event of the form, set the TimerInterval property to 60000 (a
value of 1000 represents 1 second)

Sub Form_Load()
Me.TimerInterval = 60000
End Sub

Then, add code in the form's Timer event to refresh the form:

Sub Form_Timer()
Me.Refresh
End Sub