Unwanted Parameters Show Up ina Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I had an old report wherein I changed the source and developed a new query.
The query worked perfectly when it runs by itself. However, when I run the
report, it prompts me for a year parameter. I checked everywhere and could
not find any parameters in the query. As I said before, the query works
perfectly outside of the report.

I then built a new report using the same exact query and it worked
flawlessly without any parameters popping up. That told me the parameter
issue was with the report. Where do I look to find that annoying parameter
and how can I get rid of it?

Thanks,
RT
 
In report design view, open the Sorting and Grouping dialog (View menu), and
have a peek there.

Then open the Properties dialog (View menu). Make sure you are seeing the
properties of the report (not of a text box.) On the Data tab, clear the
Filter and Order By properties, and confirm that the RecordSource is the
query you think it is.

If you are still stuck, it must be the Name or part of the ControlSource of
a control.

Or possibly Access is confused about what a field used to be named. You can
eliminate this possibility by unchecking the Name AutoCorrect boxes under:
Tools | Options | General
and compacting the database.
 
Hello Allen:

Thank you so much for your response, you were right on the money. I checked
the Sorting/Grouping and I was grouping on a field called [YR] which I had
changed to [YEAR]. When I made that change, the parameters box no longer
showed up.

What's the relationship between referencing an incorrect field and the
Parameters dialog box showing up?

Thanks,
RT
 
If Access cannot match a name to a field, it assumes it must be a parameter.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Robert T said:
Hello Allen:

Thank you so much for your response, you were right on the money. I
checked
the Sorting/Grouping and I was grouping on a field called [YR] which I had
changed to [YEAR]. When I made that change, the parameters box no longer
showed up.

What's the relationship between referencing an incorrect field and the
Parameters dialog box showing up?

Thanks,
RT

Allen Browne said:
In report design view, open the Sorting and Grouping dialog (View menu),
and
have a peek there.

Then open the Properties dialog (View menu). Make sure you are seeing the
properties of the report (not of a text box.) On the Data tab, clear the
Filter and Order By properties, and confirm that the RecordSource is the
query you think it is.

If you are still stuck, it must be the Name or part of the ControlSource
of
a control.

Or possibly Access is confused about what a field used to be named. You
can
eliminate this possibility by unchecking the Name AutoCorrect boxes
under:
Tools | Options | General
and compacting the database.
Click to expand...
Click to expand...
 
Back
Top