Auto updating a field in a subform from a yes/no in the subform

[Mazzy7]

Tricky to explain but here goes. I have a form, it contains a subform. The subform can contain several records. I have a yes/no box on these records, when I click it I would like another field "number" to be updated with the autonumber from the main form. I dont want all of the records updated, just when I click the yes/no field.

Hope this makes sense and hope you can help, its been driving me potty.

Mazzy

 

[MajP]

Run some code on the check box after update event

Untested but probably something like

private chkAssociate_Afterupdate()
if me.chkAssociate then
me!Number = me.parent.fldSomeAutoIDField
else
me!Number = null
end if
end sub