Greetings,
I am getting a Write Conflict error when making an entry in a check box on a subform.
The write conflict error has three option buttons - Save Record, Copy to Clipboard, Drop Changes. If I click Save record, the on-click event for the checkbox seems to complete OK. If I click Copy to Clipboard it takes me to another MS Visual Basic error window that says "Runtime error '3197'....you and another user are trying to change the same data at the same time." And when I click debug I get the following code highlighted that occurs in a subroutine called PrimarySoilUpdate
If DomTestOK = 0 And PrevIndexOK = -1 Then
Forms!routinewetlanddeline
ation.Domi
nant
End If
"Dominant" is the subroutine that is on the main form (routinewetlanddelineation
) but called from the subform.
There is a part of the code in the Dominant subroutine that will send me back to the subform (Page2) and run the original PrimarySoilUpdate here it is -
If Me.Soilflag Then
Forms!Page2.PrimarySoilUpd
ate
End If
If I click the Drop the Changes button I get the same error sequence as the Copy to clipboard button.
The mainform and subform are based on separate queries with about 4 fields that overlap.
Where is the source of what appears to be me trying to edit a record twice simultaneously?
Thanks,
Pat
Start Free Trial
