Autofill field based on combo box

[topp]

Hello All,



I have created a combo box that represents the status of a form (OPEN or CLOSED). What I am trying to make happen is that when the combo box gets updated to "closed" I would like the current date to automatically be filled into another form. I have created some basic code in VBA but having no experience with it doesnt help. Here is the code I have so far:
Private Sub Combo104_AfterUpdate()
If (Forms![RMA].Combo104.Value = "Closed") Then
Forms![RMA Log]![ClosedDate] = Date
DoCmd.RunCommand acCmdSaveRecord
End If
End Sub
When I try and save the record I get a run-time error of 7878: The data has been changed. Any suggestions would be greatly appreciated!!
Thanks in advance!

[June7]

Is this combobox an unbound control? The save record is acting on the form the code is behind, not the other form.

This seems like an odd arrangement. Why is the combobox not on the same form with the date field?

Want to provide the file for analysis? Follow instructions at bottom of my post.

[topp]

Lol, Thank you for pointing out the obvious to me. I for some reason was trying to set the field on another form for absolutely no reason and once I switched it to the form it was on it worked perfectly. Thank you for you help!!