I was hoping someone could help me. I am trying to create a report - a line graph which will show the number of people using a particular company per year. I want the user to be able to specify the company from a form with a drop down list. They click OK and the cmopany selected becomes the filter for the graph.
However,I am running into problems. While the report worked perfectly when coming from the base query using a parameter to insert the company name, it will not work from the form. Instead it shows values for all companies for all years.
Set the reports Filter On property to Yes and the Filter to
[Forms]![YourForm]![YourCriteriaFieldOnTheForm]=[YourCriteriaFieldOnTheReport]. When the report opens it will use the criteria entered on the form to filter.