there is an toggle button on the main form that allows the user to select whether to update the present row in the subform - one row at a time or the other option to do batch updates based on certain criteria.
When the one row at a time option is selected - the subform dta behaves as expected.
However when I invoke the batch update option and run the following Currentdb.execute statement on the refresh or requery i get the Write Conflict message - obviously when I click "save The Record" all the subsequent rows matching the criteria are updated - but I do not want the user to see that message
As a suggestion: Always add a CurrentDb.Execute strSQL, dbFailOnError
Set db = Nothing
You may have to change your Data Type to Int and or use a date so that it know what was the last record to make a comparison to.You have NON matching data is why!
It is not non-matching data and all of the records are in fact updated - however it is when I move of the record in the sub-form that the messge pops up. It is not an error - it is Jets way of saying that the reocord or recordset is being updated by another source3 (in this case the records in the update statement. )
I have seen this message before and prevented it by using :
if me.dirty = true then me.dirty = false
But it does not seem to workk at the subform level.