Timed update of listbox

T

tecman

I have a listbox designed to show work orders. I would like this
listbox to refresh in the form every 10-15 seconds or so. Any help is
greatly appreciated.
 
M

missinglinq via AccessMonster.com

This should do it!

Private Sub Form_Load()
TimerInterval = 10000 'for 10 seconds...for 15 seconds use 15000
End Sub

Private Sub Form_Timer()
YourListbox.Refresh
End Sub
 
M

missinglinq via AccessMonster.com

Actually

YourListbox.Refresh

May need to be

YourListbox.Requery
 
Top