Parameter Problem

[Nancy]

I created a report based on a several combined queries. I made a number of
changes throughout and now have it working 100%, but I have one small
problem. When I open the report I get an Enter Parmeter Value msg box. The
Parameter is: " Purchase Order.Purchase Order ID. If I hit the o.k. button
it bypasses the parmeter and the report works fine. I could not figure out
where this parameter was coming from but I am sure it was something I tried
early on and it didn't work. I opened the Report and went to the objects
dependencies. I clicked on my report and there it is: Purchase Order.
Purchase Order ID. And it says it is missing. O.K. fine I deleted it
sometime back. My question is how do I get the parmmeter msg box to go away?
I tired deleting it from the dependencis box but it will not delete. I have
searched all other tables, queries etc to see if I can find that field name
so I can delete it, but have not found it. Please help me.

 

[Golfinray]

( times out of 10 it is coming from the query. If you run all your queries
associated with the report, you will find one of them asking you for a
parameter. That is generally caused by data missing in the query or the
table, a relationship, key, or join improperly set up, or an expression in
your query that is incorrect.

 

[Marshall Barton]

I created a report based on a several combined queries. I made a number of
changes throughout and now have it working 100%, but I have one small
problem. When I open the report I get an Enter Parmeter Value msg box. The
Parameter is: " Purchase Order.Purchase Order ID. If I hit the o.k. button
it bypasses the parmeter and the report works fine. I could not figure out
where this parameter was coming from but I am sure it was something I tried
early on and it didn't work. I opened the Report and went to the objects
dependencies. I clicked on my report and there it is: Purchase Order.
Purchase Order ID. And it says it is missing. O.K. fine I deleted it
sometime back. My question is how do I get the parmmeter msg box to go away?
I tired deleting it from the dependencis box but it will not delete. I have
searched all other tables, queries etc to see if I can find that field name
so I can delete it, but have not found it.

Double check the report's Sorting and Grouping list, Filter
and OrderBy properties.

It's also possible that it mught be in a control's
ControlSource property.

 

[Nancy]

Thanks for the response, but I still can't find it. Where exactly is the
sorting & grouping and the Filter& Order by properties? Maybe I am looking
in the wrong place. I went to properties in design view and looked at each
control and I just don't see it. I went through each query one by one and
didn't find it there either.

 

[Marshall Barton]

Filter and OrderBy are properties of the report. To see the
report's property sheet, click in the little box in the
upper left of the design view where the two rulers start.
If the property sheet is not visible, use the View menu to
display it.

The Sorting and Grouping window can also be displayed by
using the View menu any time the report is in design view.

 

[Nancy]

Thank you, I thought that was where it was. I went back and double checked
those entries.

The record source is the "Orders Query'; the filter is blank; filter on load
is no; Order by is blank; Order by on load is yes; and Allow filters is yes.
I double clicked on each row and got the same answers to the questions.

Filter and OrderBy are properties of the report. To see the
report's property sheet, click in the little box in the
upper left of the design view where the two rulers start.
If the property sheet is not visible, use the View menu to
display it.

The Sorting and Grouping window can also be displayed by
using the View menu any time the report is in design view.
--
Marsh
MVP [MS Access]

Thanks for the response, but I still can't find it. Where exactly is the
sorting & grouping and the Filter& Order by properties? Maybe I am looking
in the wrong place. I went to properties in design view and looked at each
control and I just don't see it. I went through each query one by one and
didn't find it there either.

 

[Nancy]

Any other ideas on what the problem is?

Thank you, I thought that was where it was. I went back and double checked
those entries.

The record source is the "Orders Query'; the filter is blank; filter on load
is no; Order by is blank; Order by on load is yes; and Allow filters is yes.
I double clicked on each row and got the same answers to the questions.

Filter and OrderBy are properties of the report. To see the
report's property sheet, click in the little box in the
upper left of the design view where the two rulers start.
If the property sheet is not visible, use the View menu to
display it.

The Sorting and Grouping window can also be displayed by
using the View menu any time the report is in design view.
--
Marsh
MVP [MS Access]

Thanks for the response, but I still can't find it. Where exactly is the
sorting & grouping and the Filter& Order by properties? Maybe I am looking
in the wrong place. I went to properties in design view and looked at each
control and I just don't see it. I went through each query one by one and
didn't find it there either.

:

Nancy wrote:

I created a report based on a several combined queries. I made a number of
changes throughout and now have it working 100%, but I have one small
problem. When I open the report I get an Enter Parmeter Value msg box. The
Parameter is: " Purchase Order.Purchase Order ID. If I hit the o.k. button
it bypasses the parmeter and the report works fine. I could not figure out
where this parameter was coming from but I am sure it was something I tried
early on and it didn't work. I opened the Report and went to the objects
dependencies. I clicked on my report and there it is: Purchase Order.
Purchase Order ID. And it says it is missing. O.K. fine I deleted it
sometime back. My question is how do I get the parmmeter msg box to go away?
I tired deleting it from the dependencis box but it will not delete. I have
searched all other tables, queries etc to see if I can find that field name
so I can delete it, but have not found it.

Double check the report's Sorting and Grouping list, Filter
and OrderBy properties.

It's also possible that it mught be in a control's
ControlSource property.

 

[Marshall Barton]

Thank you, I thought that was where it was. I went back and double checked
those entries.

The record source is the "Orders Query'; the filter is blank; filter on load
is no; Order by is blank; Order by on load is yes; and Allow filters is yes.
I double clicked on each row and got the same answers to the questions.

If it's not in Sorting and Grouping, a report property or a
control's control source property, then I guess you're back
to the record source query. If the query is based on
another query, then check that query (and its queries) too.

If the report has a subreport, then you have an entire set
of other places to check as well.