How can I mark multiple checkboxes automatically based on report data?

[Recordsetclown]

I have a report that is a replica of a printed form. I would like to fill this form out automatically and print out the response. The report has to integrate information from two tables (related one to many) and has multiple checkboxes that could be used alone or in combination depending on the situation. This response form is based on a query that correctly identifies all the necessary information, but using iif statements in the record source for these text boxes (to place an X in the box as appropriate) only gets me information relating to the first line returned by the query. Is there some way to step through the query answer and have each box check itself if its check condition is met in any line?

Thanks for any help you can provide.