Parameter Box appears when I run report

[jas580]

When I run a report with sub-report, I get a parameter box that says
"loadRichCheap" over and over again. I continue to click cancel until the
report opens in preview mode. Everything looks perfect once it loads. I'm
guessing RichCheap is a control somewhere, but I can't find it in any of the
queries or code that are related to the sub-report. Hopefully someone can
tell me how the 'load' function(?) works so I can pinpoint this missing
parameter. Also, I know that it has to do with the sub-report, because the
master report runs fine when I remove the sub-report.

thanks,

Jeff

 

[Jeff Boyce]

Jeff

Open the (sub)report in design view, go to the VBA/code behind the form and
search for RichCheap.

Open the (sub)report in design view, identify the query that feeds it, then
open that query in design view and look for any selection criteria or
"calculated" fields.

If I had to guess, a query that feeds the (sub)report has a calculated field
named "loadRichCheap".

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jas580]

Thanks, Jeff. I had done that earlier, but this time I clicked "search
project" instead of "search module" and found it deeper than I thought it
would be.

Thanks for the help!

-jeff