Checkbox on Subform not Writing to Table

[besuchanko]

I'm halfway there on this but need some help. I have a main form with a subform. When I update the textbox on the main form (Submission_Title), I use the AfterUpdate event to check a checkbox on the subform. That works fine. But when the checkboxes get checked on the subform, they don't write back to the table linked to the subform (tblPinkSheetData). How do I get it to write to the table??

Private Sub Submission_Title_AfterUpdate()

Me.tblPinkSheetData_subform.Form!R1.Value = -1


End Sub

[Micron]

You are probably not saving the record you've just modified. Could try adding something like
Forms!NameOYourfMainform.tblPinkSheetData_subform. Form.dirty = false

or do something to move off of the subform record. Remotely possible that the table is already open and you're switching back to it but not refreshing the view.
EDIT - code edited.

[apr pillai]

I'm halfway there on this but need some help. I have a main form with a subform. When I update the textbox on the main form (Submission_Title), I use the AfterUpdate event to check a checkbox on the subform. That works fine. But when the checkboxes get checked on the subform, they don't write back to the table linked to the subform (tblPinkSheetData). How do I get it to write to the table??

Private Sub Submission_Title_AfterUpdate()

Me.tblPinkSheetData_subform.Form!R1.Value = -1


End Sub

Add one more line to your subroutine.

Private Sub Submission_Title_AfterUpdate()

Me.tblPinkSheetData_subform.Form!R1.Value = -1

DoCmd.Save Me.CurrentRecord
End Sub

[Micron]

Private Sub Submission_Title_AfterUpdate()
That code is on the main form so DoCmd.Save Me.CurrentRecord applies to the main form. However the edited checkbox is on a subform?

[apr pillai]

You are correct Micron, sometimes I am so careless and hurry with responses.

Private Sub Submission_Title_AfterUpdate()
Dim frm as Form
    set frm = Me.tblPinkSheetData_subform.Form
    frm!R1 = -1
    DoCmd.Save frm.CurrentRecord
End Sub

I hope it will work, but not tested.