Refreshing a form

  • Thread starter Thread starter Ana
  • Start date Start date
A

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!!!
 
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
 
Back
Top