write conflict

[McRoberts]

I have a main form (frmIandRSurvey) with combo box for Status (Yes/No).
I have four subforms and on each subform I have a combo box (Yes/No) that has code on the After Update as follows:

Private Sub Returned_Call_After Update()
If Me.Returned_Call = "Yes" Then
Forms!frmIandRSurvey!SurveyIntroTab.Visible = True
Forms!frmIandRSurvey!SurveyIntroTab.Enabled = True
Forms!frmIandRSurvey!SurveyIntroTab.SetFocus
Me.Requery
Else
Forms!frmIandRSurvey!SurveyIntroTab.Visible = False
Forms!frmIandRSurvey!SurveyIntroTab.Enabled = False
Forms!frmIandRSurvey!Status = "CLOSED"
Me.Requery
End If
End Sub

Basically, on these combo boxes (yes/no) in each tab, if Yes is picked I want the next tab to become visible and it sets focus to it (this works fine) and if No is selected then I want the next tab to remain invisible (this works fine) and the "Status" on the main form frmIandRSurvey to change to CLOSED.

This all works fine, but when I try to save I get a write conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

I know that I am the only user in the database so I believe that it has something to do with my subform changing information in my main form but I don't know how to fix it.

Can anyone help?

Thank you in advance.