unnecessary parameter prompt? 1

[thatguy]

Hey there folks--

I've searched for this topic and found a couple posts, but none of them had any real answers (that worked anyway). And I also have another question..

I have a main report based on a query. The query correctly brings up all 5 records in the master table (and all related data, too). In the main report is a subreport (in the header band) based on another query. That query runs correctly on its own too. However! When I run the main report, a paramater prompt box pops up with the prompt message of the name of my master table, and the value I enter into the box has no effect on the report.

Second question: when I bring up the main report, it onlys shows one record, but when I run the query (that the report is based on) on its own, there are 5 records returned. I don't have any filters set on the report, so i'm wondering... where are the other records??

Any help would be great. Thanks
-- michael~

 

[jdegeorge]

thatguy

If your query isn't supposed to ask the user for input, maybe you have an incorrectly spelled field in the query, which can be interpreted by Access to ask for input.

Are you sure that every query element is a field?

Jim DeGeorge
Developer

 

[thatguy]

yes.. I used the query designer (didn't type in anything) and used the drop-down in the properties window to select the controlsource for all the report controls. the odd thing is that it doesn't prompt for any particular field, the prompt is for the underlying master table name ("MASTERQUOTE&quot.

 

[thatguy]

well I figured it out... for anyone else that has this problem: the cause was using a master query field name as the Master Link field. Instead, I put a control bound to the Master Link field (with visible prop set to False) and used the control name as the Master Link field. Why this fixed the problem - I have no idea.
-- michael~

 

[JDavey]

I had a similar problem with an unexpected parameter window appearing. I removed the "total" column from the xtab query but hadn't removed it as a sort option in the report.