changing report criteria via a form

[Andrew Green]

Hi all,

This is my setup:

1 query which contains a category field (among other things)
1 report based on this query
1 form with a checkbox for each category available in the category field - note, these checkboxes are not linked to any data, the are simply option settings for producing a summary report.

I wish to tell the query to only print the the categories which are checked on the form. What is the best way to do this?

I have tried using multiple IIF() statements on the query criteria to look at the selected options on the form, but Access reports that the query calculation is too complex.

Any ideas?

Thanks,

Andrew.

 

[Andrew Green]

It's working now. I just put all the options into a single criteria field on the the query.

E.g. IIF([Forms]![ReportForm]![ThisCheckbox], "Category A") Or IIF([Forms]![ReportForm]![ThatCheckbox], "CategoryB") Or... etc.

Andrew.