Locking tables useing list boxes

[Dave]

Hi,

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

however this locks up the table, how can i get the same effect without
locking the table

cheers
Dave

 

[MacDermott]

In my experience (I've just tried it) using a table as a rowsource for a
listbox does not lock it for other uses.
Perhaps you mean that you can't edit the data directly in the listbox?
That is by design; listboxes never work that way.
If you want to display rows of data and be able to edit them, you might
consider using a subform...

HTH
- Turtle

 

[Dave]

No i dont want to edit.
Sorry i should explain myself better
What i mean is that 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