Listbox row source and record locking?

[sk]

I'm setting up my first true multi user database and I have a question on
record locking.

If I set a list box row source type to "table/query" and specify a select
query for it, does Access lock those records? In the past I have always used
"value/list" and loaded the records with code but it would be much easier to
use ""table/query" if it does not lock the records.

 

[Arvin Meyer [MVP]]

In most cases, Access only locks an editable record. The select statements
in list and combo boxes do not lock the table because you aren't editing
those records.

Make sure that you split your database in a multi-user environment. See:

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm