>I have a table called jobqueue. When a user wants to print a report or run a task I write a record to the jobqueue table which stores the type, username, datetime and status. I have created a form with a listbox which is bound to this table. Do I have to have some kind of timing event so that the listbox refreshes say every 2 seconds?
>
>Many Thanks
Neil
If you think the source will be updated so frequently, I guess yes.
Issue a Thisform.lstMyList.Requery().
Not sure what'll happen if the list is being requeried while you're dropping down the list. Maybe in the GotFocus() of the listbox you could have code to suspend the timer, so it won't be "tampered with" while you're accessing it.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.