Write Conflict ( save to clipboard etc. ) ?

[liamfitz]

When I change a date field in a subform it opens a Form ( as it should ) and I select an item from a combo box. On closing this Form, it references the record on the opening subform ( works correctly ) and updates a field in it ( not shown on subform/recordset). However, on closing the Form containing the aforementioned subform, I get the write conflict error with 3 options about saving the record, copying data to clipboard etc. How do I 'get round' this, and what causes it ? Thank you.

 

[AccessMSSQL]

Are you using VBA to update the record in the subform? If you try to update a record in VBA through a SQL statement where the record is opened in a form you will get this message. The system sees that some other process has tried to change the record you have opened before you have saved it.
when you change the date field in your subform, first do a refresh of the data in the record before you open your pop up form. See if that helps.

 

[boblarson]

Issue a save command in the code which opens the other form:

If Me.Dirty Then Me.Dirty = False

 

[liamfitz]

Many thanks boblarson. It's works perfectly. You're expertise has been invaluable.