refresh form automatically

[Vespertin]

hello

can anyone advice the best way for a form to refresh automatically say every 5 minutes when the form is open?

Thanks for any advice you can give.

 

[bob fitz]

Hi Vespertin

I'm not very familiar with the details, but I believe this can be done using the On Timer and TimerInterval form events. Here's an example from the help files.

Sub Form_Load()
    Me.TimerInterval = 1000
End Sub
 
Sub Form_Timer()
    Static intShowPicture As Integer
    If intShowPicture Then
        ' Show icon.
        Me!btnPicture.Picture = "C:\Icons\Flash.ico"
    Else
        ' Don't show icon.
        Me!btnPicture.Picture = ""
    End If
    intShowPicture = Not intShowPicture
End Sub