Updating data

[Withnail]

I am opening up a Form (Form2) based on data in Form1. When the user closes Form2, I wish a Yes/No field in the record on Form1 to be updated. I am receiving an error message:

Run-Time error '7878'
The data has been changed.

Here is the code for closing Form2:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close acForm, "Frm_MTR_Add_Details_Dev_Analysis"
Form_Frm_MTR_View_Status_FA_By_Developer.SetFocus
Form_Frm_MTR_View_Status_FA_By_Developer.Fault_Analysis_Performed.Value = True
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close acForm, "Frm_MTR_View_Status_FA_By_Developer"
DoCmd.OpenForm "Frm_MTR_View_Status_FA_By_Developer", , , "Name = '" & MTRDbUser & "'"

Hope this makes sense. I was unable to put the Yes/No field on Form2 as this made the recordset not updateable.

Regards

Mark

 

[Withnail]

I forgot to mention that the error message was received on the fourth line of the above code:

Form_Frm_MTR_View_Status_FA_By_Developer.Fault_Analysis_Performed.Value = True

 

[Rich]

Is that really the name of the form or the field? You have made life very difficult for yourself by naming fields in this way. You need to tell us what's what here.