Report requesting paramater multiple times

[RWatson1]

Hello,

I have created a query with parameters and a report from the query. The report is requesting the paramater multiple times but the query is running fine. Does anyone have any ideas on how to resolve? Again, the query requests the parameter once but the report multiple times (6x).

 

[Brianwarnock]

If you are using a pop up box the parameter will be requested every time it is used. Use a form to supply the parameter reference it by

Forma!theformname!thecontrolname

Brian

 

[RWatson1]

Thanks Brian. I will use this option.

 

[sumox]

YA CREATE A FORM NAMED "SearchBox" or anyname
Then Create textboxes for feeding parameters to Report
Rename them as per your choice
and then in Query , where you've placed filter criteria
Type as said by Brianwarnock !

Thanks for reading