How to set ListBox as Read Only in Access 2000
Posted on 2011-03-24
I am trying to figure out how to make a ListBox's rowsource recordset be Read Only.
I am assumming it is not by default. When opening a recordset using Set RS= "sql string, etc, etc", I know I can specify a dbOpenSnapshot option, but can't figure out how to accomplish this in a SQL statement within Access.
This is an example of how I am defining the row source for the list box:
SqlString="Select * from tblCustomers"
I don't want a lock on that table when filling the list box.