Running sub-report coding

[SueBK]

I have some 'on load' code sitting on a sub-report, for a series of checkboxes (one bound and one unbound showing the opposite of the bound box)
Me.Check1 = Not Me.Check2

It all runs fine in the sub-report, but the 'on load' code is not running when I open the main report. I assume I have to transfer this code to the main report's on-load code.

How do I do this?

 

[SueBK]

I've added new fields to my query "FieldNameNO: not [Fieldname]". I've then set "FieldNameNo" as the control of an unbound checkbox on my report. Glad I only have 8 fields.