 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / August 2006asked for parameter
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.).  SignatureKen Snell <MS ACCESS MVP> > When I go to view my report it prompts me for the parameter value of > 'Freq' [quoted text clipped - 3 lines] > appropriate information in it. How do I stop it prompting me for that > parameter? 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? > 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 [quoted text clipped - 8 lines] > > appropriate information in it. How do I stop it prompting me for that > > parameter? You need to include Freq field in the subreport's recordsource query. SignatureKen Snell <MS ACCESS MVP> >I do have Freq in a subform and in that subform i am sorting Freq >Ascending. [quoted text clipped - 13 lines] >> > appropriate information in it. How do I stop it prompting me for that >> > parameter? Sorry I am unsure what you mean by this. > You need to include Freq field in the subreport's recordsource query. > [quoted text clipped - 15 lines] > >> > appropriate information in it. How do I stop it prompting me for that > >> > parameter? 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. SignatureKen Snell <MS ACCESS MVP> > Sorry I am unsure what you mean by this. > [quoted text clipped - 22 lines] >> >> > that >> >> > parameter? I checked and Freq is in the source query but it still asks for the parameter > 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 [quoted text clipped - 28 lines] > >> >> > that > >> >> > parameter? 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? SignatureKen Snell <MS ACCESS MVP> >I checked and Freq is in the source query but it still asks for the >parameter [quoted text clipped - 33 lines] >> >> >> > that >> >> >> > parameter? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.