Please bear with me while I try and explain this...
My tables are linked sharepoint lists.
I have a form with 2 subforms showing in datasheet view. They each show data from the same table (Exceptions) with slightly differing criteria.
I have a column in each table that is a tickbox which is unticked by default. I don't have any record locks on either of the subforms but do allow edits to allow tickbox to be checked.
I have an update query that looks for any records which are ticked and it updates a name column. The name column is added via a dlookup to another table (Members) using a text box value from the main form.
The issue I'm facing is if I tick only 1 box and run the update query I get a lock violation. If I tick 2 or more boxes and run the update query the last record ticked gives the lock violation but the other 2 are updated ok.
I've tried to set focus to a text box on the form before running the update query but have the same issue. Any idea?
My tables are linked sharepoint lists.
I have a form with 2 subforms showing in datasheet view. They each show data from the same table (Exceptions) with slightly differing criteria.
I have a column in each table that is a tickbox which is unticked by default. I don't have any record locks on either of the subforms but do allow edits to allow tickbox to be checked.
I have an update query that looks for any records which are ticked and it updates a name column. The name column is added via a dlookup to another table (Members) using a text box value from the main form.
The issue I'm facing is if I tick only 1 box and run the update query I get a lock violation. If I tick 2 or more boxes and run the update query the last record ticked gives the lock violation but the other 2 are updated ok.
I've tried to set focus to a text box on the form before running the update query but have the same issue. Any idea?