asked for parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.).
 
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?
 
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.
 
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?
 
Back
Top