when i run my program and update a field called Date_Closed the program will update it the first time. If I go back and try to update the record again or erase the Date_Closed field I get an error: "Runtime 3426 This action was cancelled by an associated object"

here is the code:

Private Sub cmdUpdate_Click()
'getting error code here!!!
Data2.Recordset.Edit
Data2.Recordset.Update
Data2.Recordset.Edit
Data2.Recordset.AddNew
'Data2.Refresh


why does it work once and then fail? anyone have any ideas again this is databound so I know their are bugs anyone know a fix?