Timer +Event

[davetek]

Hey,

I have a form, which displays data from tables...multiple users input data to these tables....
what i need to do is have this form refresh every 30 secs or so.....
i have a refresh button which does the trick:

Sub refresh()
Form_ViewData.Refresh
End Sub

however, what i want, is to execute this function with a timer.....

anyone?

cheers...

 

[BillPower]

Hi davetek,

Open your form in design view, set the Timer Interval to 30000.

In the On Timer event:

Form_ViewData.Refresh

Should do what you want.

Bill

 

[BillPower]

Hi davetek,

Actually, that should have read:

Me.Refresh

Or

Forms!Form_ViewData.Refresh

Form_ViewData.Refresh isn't correct syntax, though it might have worked for this method, for other methods you might experience problems.

Bill