Multiple Parameters

  • Thread starter Thread starter Tony Montana
  • Start date Start date
T

Tony Montana

I have seen this posted before but cannot get the code to work for my report.
I'm still only a novice. I have a report based on a query that shows 5
charts. When I run the report it asks for the date or any other parameter
that I select 5 times. How can I get the report to run with the parameter
only being asked for once like in the query. I have a report which is run by
a date range, and a report which is run by a field called Outbase.

Huge thanks in advance as this will save me so much time.......
 
well one method would be to create a little form or use an open form - and
put that date in an unbound text box that serves the purpose of holding that
date.

or on the otherhand perhaps you have already an open form with that date there

put the criteria for those queries to be the field of that form:
Forms!FormName.FieldName

this way the query will look to the form for that data and not to you....
 
Back
Top