Refresh All SubForms

[deagio]

Hi,

I have a form called [Summary] with three subforms on it, [Skips_Avaliable] [Delivered Orders] [Completed Orders].

And I was wondering if it would be possible to refresh all the subforms on the form every 30 seconds or so, any ideas if this is possible?

Thanks,


James

 

[llkhoutx]

Use the OnTimer event, setting the form "Timer Interval" property to 60000, e.g.

Private Sub Form_Timer()
forms!MainForm!Subform1.form.refresh
forms!MainForm!Subform2.form.refresh
forms!MainForm!Subform3.form.refresh
end sub

 

[deagio]

hi

Hi,


Thanks for that, works perfectly!


James

 

[FISHiEE]

Solved my problem too. Cheers!