write conflict “record changed by ..”Locked
I have a form with subform. The subform has a check box that when checked kick off processes that I have programmed in the after update event. The main process is to open a recordset (the same query that runs the subform) this recordset will make some changes to the current record and sometimes add an additional record. The problem is when you are returned to the form you receive an error “record has been changed by another user”. To avoid this I had to close the form and reopen it after the recordset has been edited. This is not great because the form is reset to all records and a password text box is reset. Why is it that I can’t change the records with my recordset and see the updated record in my form. Yes I have tried to requery, and repaint my form. This is causing me headaches. Really need some help here.