Ok, now my button click has the following code.
If Me.Dirty Then Dirty = False
DoCmd.OpenQuery "AssignToMeUpdate"
It gives the same lock violation. I don't quite understand the dirty property, would I not have to check the dirty status of the subform rather than the main or does the main...