I've resolved this issue before, but I forget how!
The problem is, when I press a button on the form it runs some update querys, If the form has had some input then this creates a conflict.
I thoughtbefore the code would save the updated fields before running the query, but in this case that doesn't seem to help.Code:docmd.save
I know that is how to resolve it. It needs to be saved prior to the update query running. But This line isn't achieving that.