I have a drop-box on a main form. There is a subform on the main form.
After update of the drop-box on the main form, the following code update the recordsour-table of the subform:
CurrentDb.Execute "Update tOwnerDRF_Titles Set BU_ID=" & Me!cboBusinessUnit & " Where OwnerDRF_ID=" & Me!OwnerDRFID
'Me!sfDRF_TitlesTempUpload.Form.Dirty = False
'Me!sfDRF_TitlesTempUpload.Form.RecordSource = Me!sfDRF_TitlesTempUpload.Form.RecordSource
However, When I go from one record on the main form, I get "Write Conflict" message which I am trying to avoid. Additional information is provided on the attached image.
Question: How can I get rid of the "Write Conflict" message?