Timed update of listbox

  • Thread starter Thread starter tecman
  • Start date Start date
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.
 
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
 
Actually

YourListbox.Refresh

May need to be

YourListbox.Requery
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox SQL problem 2
transfer data from one listbox to another 2
Access Cannot select items in listbox 1
Requery not working 8
Cannot Get ListBox .ItemsSelected, help! 1
Listbox Double Vision 6
populate table using multiselect listbox 1
Listbox - Change underlying field value. 2

Back
Top