<< Just needing to understand the logic of the variable lookup list view concerning Locks. >>
The trick is that you should NOT attach the form to the table used by the listview. If the form is based entirely on the listview and doesn't directly display data, it can be a variable (table-less) form, or you can base it on a one-row dummy table. The table from which the list view draws its data should not be the driving table. If you do this, the table from which the listview draws its data will not get locked. -- Larry
