Subform checkboxes setting main form checkbox

[Bill the Cat]

Good morning,



I have a filtered form with 2 checkboxes. One is for "Sub-Family Satisfied" and the other is for "Sub-Family Other Than Satisfied". The sub-form is filtered on the Sub-Family Number textbox and has between 3 and 12 records per sub-family. On each record on the sub-form, there are 2 checkboxes for "requirement satisfied" and "requirement other than satisfied". I need to have the Sub-Family Satisfied checkbox on the master form checked if ALL of the "Requirement Satisfied" checkboxes for all of the filtered records are set or the "Sub-Family Other Than Satisfied" checkbox set if ANY of the "Requirement Other Than Satisfied" checkboxes are set.

Here's a snip of my form with the pertinent fields.




Thank you!

[Bulzie]

Maybe in the Subform on the AfterUpdate event, check the check boxes and run Update code if needed to update the values in the main table. Something like:

Set dbs = CurrentDb

If Me.RequirementSatisfied= True Then

dbs.Execute "UPDATE tblMain
SET [tblMain].[SubSatisfied] = True
WHERE ([MainID] = Forms!frmMain.frmDetail![MainID])"

Forms!frmMain.Requery

End If

Something like that.