Subreport/query causing repeating Parameter question

[Maryanne]

I have a subreport/subquery that is based on a query that asks the user to input either 1999 or 2000. When I try to run the report, the parameter query repeats three times. Can I get the subquery to "get" the year from the main query?

 

[Travis]

Best way around this is to have a form lauch this report. Have it asked the question prior to launching the report.

Now on the query change the parameter from being =[Your Year] to =Forms![YourFormName].[YourFieldName].

In this case using a combo box with limit to list will avoid invalid responses.

Hope this helps