When leaving a subform I get write conflict. "Another user has changed the record. Save Drop or copy to clipboard".
In this subform I set a main form field value from the subform. So it may be that the main form's record is needing saving rather than the subform's record? I can't seem to find the secret of how to do this.
I have a "Close" button on the subform that moves the focus to the main form and then sets the subform visible property to false. It is doing this that causes the error