Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I stop the expression Enter Parameter Value?

6 views
Skip to first unread message

Rodriguez@discussions.microsoft.com Eric Rodriguez

unread,
Apr 5, 2005, 5:57:02 PM4/5/05
to
I have a report that used to draw from Query A. One of the fields in the
report, "Nominator," got its information from Query A.

I've removed that field and changed the underlying query to Query B. But,
when I try to open the report, a pop-up comes up that says "Enter Parameter
Value" and says "Nominator." The thing is, the report is now drawing upon
Query B, there is no "Nominator" field in Query B and there is no "Nominator"
field in the report. Can somebody help? Thanks.

Duane Hookom

unread,
Apr 5, 2005, 6:18:53 PM4/5/05
to
Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" <Eric Rodr...@discussions.microsoft.com> wrote in message
news:1D71CA53-1CA2-41D1...@microsoft.com...

Duane Hookom

unread,
Sep 7, 2005, 1:06:50 PM9/7/05
to
The Sorting and Grouping dialog is opened by View->Sorting and Grouping. If
you want to remove these, click the selector button to the left of the
expression and press the delete key.

--
Duane Hookom
MS Access MVP


"Andy Dorph" <Andy...@discussions.microsoft.com> wrote in message
news:4B08A7BA-F5C7-42A8...@microsoft.com...
> Doing research on a similar problem. Not too clear on what is meant by
> the
> statement "Check the Sorting and Grouping dialog." What need to be done
> in
> the dialog?
>
> In my case, I have created 4 groups. for the sake of argument, let's call
> them grp1, grp2, grp3, grp4. They are not based on any data elements in
> the
> tables. When I run the report, I receive the enter parameter input box
> for
> each of these. How do I turn these off?

Andy Dorph

unread,
Sep 8, 2005, 9:28:03 AM9/8/05
to
Removing the grouping is not an option for me. Is there some way I can
programmatically override the request for the parameters?

Thanks

Duane Hookom

unread,
Sep 8, 2005, 10:40:57 AM9/8/05
to
It isn't clear what is causing the parameters and why. If they are coming
from expression entered into the sorting and grouping then either delete
them or suggest why you won't delete them.

--
Duane Hookom
MS Access MVP
--

"Andy Dorph" <Andy...@discussions.microsoft.com> wrote in message
news:57F6F05E-AAAA-41FF...@microsoft.com...

Marg

unread,
Jan 5, 2010, 9:55:01 AM1/5/10
to
The parameter keeps popping up because it needs to be removed from the
Parameters dialog box in the query. Even when you remove it from the query
grid you have to remove it from the Parameters box as well.
0 new messages