View Full Version : Mysterious 'Enter Parameter Value' Box


chris01252
07-23-2007, 02:56 AM
I have a report that that when run, a 'Enter Parameter Value' box pops up for Total.

I am 100% sure there is no tags in the report, i.e [Total] which would genrate this as I have been through it meticulously.

When I run the query the report uses separetely it gives me the data I need without the Parameter Value Box appearing.

What ever I enter in the box does not seem to modify the results it is just very annoying.

Any ideas why this may be happening would be greatly appreciated.

:confused:

The_Doc_Man
07-23-2007, 05:18 AM
For some reason your report thinks it is based on a parameter query. The dialog box should include name of the parameter (I think).

You have spelled something incorrectly OR something about the reference in the report uses a bad "reference path" to find the item you wanted. Like, if you have a reference to [Something] but you might really need to use [MyQuery]![Something] or Forms![MyForm]![Something]

boblarson
07-23-2007, 05:27 AM
And sometimes you won't find it in the report or in the code, but you will find it in Grouping and Sorting (View > Grouping and Sorting) because you may have selected one thing when you originally created the report and then you changed the name of something in the report's recordsource, or something, and it now is trying to find that item to sort on.

The_Doc_Man mentions that something might be spelled incorrectly, and that is the highly likely thing, but the Sorting and Grouping thing is a common mistake too (I've been burned by that one before), so be sure to check it out and make sure if you still can't find the problem.