Hi All
I have a main form which I have put a sub form which has a list box. The sub form is refreshed every minute to update the listbox with current information. The problem is there are other forms on the same database.
In these forms they send e-mails of templates. Since I began refreshing the sub form on the main form the e-mail from time to time freeze. What can I do to stop this happening
Thanks

Brendan Bartley

__________________
Brendan Bartley

Have tried refreshing ONLY the row source of the listbox instead of the source object of the whole subform? Perhaps it's tying up your resources to do the latter.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Brendan,

Sounds like Serrano is right, the system has its resources tied up processing the ListBox refresh. This
is due to the Single-threaded nature of VB/VBA.

Couple few questions:

• Is this all on a single machine - accessed by a single user?
• How is the ListBox linked to the data?
• How are you performing the refresh?

Best Regards,
Rob

The DB is on a server accessed by 10 users
The listbox is on the main form. Holds current issues for the end users to be aware of during the day.
I was updating it by timer function every 5 min.
The problem is that the forms on this DB are completed by end user and e-mailed . The timer function at certain times froze the e-mail and the form.
Thanks

Brendan Bartley

Well, no, that's not what I said. I suggested that Brendan refresh ONLY the listbox row source instead of the whole subform source object. It'd mean less data to update. So...

So not

Me.MySubForm.Form.Requery

It'd be more like

Me.MySubForm.Form.MyListBox.Requery


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

That fine it updates the sub form in my main form of the DB but does not update anyone elese on the network main form
Thanks

Brendan Bartley