unbound form to lock several records in table from recordset

[northernbeaver]

ok heres the long and short of it. I have a table called tblWorkOrders. I have a form where filters can be applied to display records from tblworkorder in a list box with multiple selects enabled. the user is to select which work orders in the listbox that they wish to edit and hit a button. from here I want to bring up a form that displays all the work order details for editing (one record at a time) but I want all the selected records to be locked in the table as this database is in a multiuser environment. any thoughts and suggestions as to the best way to proceed? I must ensure that peoples changes are not overwritten and I think the best way to do this is to deny access to the records upon selection. thanks for any input you can provide

 

[vbajock]

Look at the RecordLocks Property of forms in the help file. Set this property to 1 (All records) to throw a table lock on the underlying recordset.