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?
Subreport/query causing repeating Parameter question
- Thread starter Maryanne
- Start date
Travis
Registered User.
- Local time
- Today, 08:29
- Joined
- Dec 17, 1999
- Messages
- 1,332
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
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
