asked for parameter

[Nikki]

When I go to view my report it prompts me for the parameter value of 'Freq'
which is one of my field names. I have double checked it is pointing the
right place in the queries, tables etc and when the report shows it has the
appropriate information in it. How do I stop it prompting me for that
parameter?

 

[Ken Snell \(MVP\)]

By chance, do you have a subreport on the report? if yes, check the
subreport for any use of the Freq field name (Sorting & Grouping, control
with a Control Source expression that uses that name in the expression,
etc.).

 

[Nikki]

I do have Freq in a subform and in that subform i am sorting Freq Ascending.
Does that effect it? How do I stop it from asking for it?

 

[Ken Snell \(MVP\)]

You need to include Freq field in the subreport's recordsource query.

 

[Nikki]

Sorry I am unsure what you mean by this.

You need to include Freq field in the subreport's recordsource query.

 

[Ken Snell \(MVP\)]

The subreport has a RecordSource property, which usually is a query. That
query must include the Freq field from the source table as one of the
selected fields.

Otherwise, delete Freq from the sorting box in the subreport.

 

[Nikki]

I checked and Freq is in the source query but it still asks for the parameter

 

[Ken Snell \(MVP\)]

Post the SQL of the subreport's recordsource query.
When you say Freq is used for sorting, is that in the Sorting & Grouping
functionality? Post the exact spelling of what is there.
Is Freq referenced anywhere within the subreport's controls' ControlSource
expressions?