Thanks for your help, I have this sorted out finally. Each of the checkboxes is it's own tiny subform that is related to it's own query. Definitely not something I would have initially thought of.
It works, so I'm not complaining. Now on to the most time consuming task, making it look good...