Missing Parameter?

[Gerry]

Is there a way to find a missing para,eter? I copied a report from a database
into my current database. I matched up all the fields with my fields and the
report runs when I preview it. The problem is, a pop up window keeps opening
asking me for input. I wnet into the code to find this missing parameter but
I cannot find it. Is there a secret way to find it that I don't know about?

Thanks

Gerry

 

[Al Campagna]

Gerry,
Make a backup copy of your original report!
We'll just have to start drilling down through possible causes...

Does the query behind the report run without a prompt?
If no prompt, then move on to the report.
If prompt, then Cut/Copy half the query elements, and try again.
Use this same drill-down logic to pinpoint the problem in these
other areas...

Check the Sorting and Grouping for fields that create a parameter
request.
If not an S&G field then...

Copy/Cut all the code in the module, and preview the report. Get a
Prompt?
If not... Paste back the code.

Copy/Cut half the controls on your report, and preview it. Get a
Prompt?
If so, paste back your cut fields, and try the cutting the other
half. Get a Prompt?
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."