Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unhappy Unanswered: Report - Filters and Graphs

    Hi all,

    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.

    Can anyone tell me what I am doing wrong?!



  2. #2
    Join Date
    Mar 2003
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts