Yet another "Enter Parameter Value" question

[creolejazz]

Hi. I have created a simple query using four fields from a table. I then created a report based on that query that displays those four fields.

When I open the report, however, I get an "Enter Parameter Value" message with a field name that I'm not using in either the report or the query (although it is a field in the original table).

What problem does this indicate and how can I eliminate this? Thanks.

 

[MSAccessRookie]

Hi. I have created a simple query using four fields from a table. I then created a report based on that query that displays those four fields.

When I open the report, however, I get an "Enter Parameter Value" message with a field name that I'm not using in either the report or the query (although it is a field in the original table).

What problem does this indicate and how can I eliminate this? Thanks.

I can think of two possibilities here:

1. The name of One or more columns in the table was changed, and one was not updated
2. There is an error in the spelling of the column name.

Since you said "although it is a field in the original table", I choose #1 as the higher probability.

If you look at the report in Design Mode, you may see a green arrow in the corner of the control in question. The green arrow indicates an error in the control definition. Clicking on the arrow displays a menu that will help you to correct the problem.

 

[creolejazz]

Thanks for the feedback. Here's what it turned out to be.

I opened the table and noticed TWO column headings with small "up" arrows on the right side indicating they had been sorted at some point. I cleared all sorts then created a new report from scratch (based on the original query) and it opened fine. No "Enter Parameter Value" message.

Thanks again. Your "arrow" comment got me looking around.

 

[MSAccessRookie]

Thanks for the feedback. Here's what it turned out to be.

I opened the table and noticed TWO column headings with small "up" arrows on the right side indicating they had been sorted at some point. I cleared all sorts then created a new report from scratch (based on the original query) and it opened fine. No "Enter Parameter Value" message.

Thanks again. Your "arrow" comment got me looking around.

Glad that your problem has been resolved. I have been assisted many times by the people in this forum. I am always please whenever I can assist another person.