Parameter problem in report..

[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?

 

[Marshall Barton]

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?

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