D
Dave
I curently use the following method to populate a list box
Private Sub Form_Open(Cancel As Integer)
varstr = "SELECT UserKEyID, UserID, FullName FROM tbl_Users"
Me.lstUsers.RowSource = varstr
End Sub
If a form has a listbox on it and that list box's
rowsource has been defined as above then
If you try to go into that table in design mode (while debugging/developing)
you can't
Therefore there must be something that links the Listbox to the table.
This in turn must hog up some of my network/Server resources etc.
I dont know how much this is and i dont think its much but
the database has about 30000 customers on it and hundreds of thousands of
orders.
On some screens without any filters set it is possible to display them all
This must have an effect if a user goes into a form looks up some
information and then leaves the form open.
What i would like to do is:
be able to open the form and populate the list box and hold the info in
memory locally .
I have thought about using a make table query (make the table on the front
end) and using that as the source.
or is it possible to open a recordset and use that for the source of the
listbox
thanks
Dave
Private Sub Form_Open(Cancel As Integer)
varstr = "SELECT UserKEyID, UserID, FullName FROM tbl_Users"
Me.lstUsers.RowSource = varstr
End Sub
If a form has a listbox on it and that list box's
rowsource has been defined as above then
If you try to go into that table in design mode (while debugging/developing)
you can't
Therefore there must be something that links the Listbox to the table.
This in turn must hog up some of my network/Server resources etc.
I dont know how much this is and i dont think its much but
the database has about 30000 customers on it and hundreds of thousands of
orders.
On some screens without any filters set it is possible to display them all
This must have an effect if a user goes into a form looks up some
information and then leaves the form open.
What i would like to do is:
be able to open the form and populate the list box and hold the info in
memory locally .
I have thought about using a make table query (make the table on the front
end) and using that as the source.
or is it possible to open a recordset and use that for the source of the
listbox
thanks
Dave