Parameter problem in report..

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have created a report based on a query, the query has a
parameter. When i preview the report the parameter dialog
box appears where it then asks for specific criteria. This
is exactly what i want it to do however, when i input the
criteria and press enter the parameter appears again, and
again and again. Why does the parameter dialog box appear
3 times before it displays the report?

It is doing my head in! lol

Can anybody help me?
 
Mike said:
I have created a report based on a query, the query has a
parameter. When i preview the report the parameter dialog
box appears where it then asks for specific criteria. This
is exactly what i want it to do however, when i input the
criteria and press enter the parameter appears again, and
again and again. Why does the parameter dialog box appear
3 times before it displays the report?
Click to expand...

You and your users would be better served if you'd create a
form for entering the parameter values. Then the report and
subreport queries can refer to the controls on the form
instead of prompted for them. The query criteria would be
specified using syntax like this:

Forms!theformname.atextboxname
 
Back
Top