display all recods in report

[deekras]

i have a form where the user can select which category to display in report. how can i set it up for the user to select one category or all categories for the report?

 

[doulostheou]

Just base the report off of a query that links to the form where they select the category. You can write the criteria in the query to pick the selected category or to run normally if the field is left null (select all categories). I believe the syntax you would write in the criteria of your query is below:

Like IIf(IsNull([Forms]![Form]![Category]),"*",[Forms]![Form]![Category])