Unknown popup?

[KeithB13]

Hello all,
I am having a problem with a report and I have exhausted my resources.

I have a report that I am running that uses a text box value in a 'where' statement created from a macro. ""[PIR_number]=[Forms]![PIRMain_form]![PIR_Number]"" The report contains a sub-report that brings up values by related records. The report works just fine. The correct information is displayed for each record.

My problem is this...Every time I run the report from a 'command button', a popup menu appears that wants me to 'enter a parameter value'. The field that it is asking for comes from my sub-report. I have looked at all queries and SQL statements that are related to the report and I can't figure out why it is asking me for this value. Does anyone have any ideas?

Thanks,
Keith Bledsoe

 

[Pat Hartman]

Look at the subreport's sorting and grouping properties and see if the field is referenced there.
Look at the subreport's data properties tab and see if the filter is the problem.

 

[KeithB13]

Thank you very much,

The problem was in the sorting and grouping in the main report, not the subreprot. Your tip put me on the right track.

Thanks again,
Keith Bledsoe