How do I stop the expression Enter Parameter Value?

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.

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in message
...
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.

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?

"Duane Hookom" wrote:

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in message
...
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.

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" wrote in message
...
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?

"Duane Hookom" wrote:

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in
message
...
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.

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" wrote:

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" wrote in message
...
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?

"Duane Hookom" wrote:

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in
message
...
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.

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" wrote in message
...
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" wrote:

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" wrote in message
...
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?

"Duane Hookom" wrote:

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in
message
...
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.

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.

"Duane Hookom" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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?

"Duane Hookom" wrote:

Check the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP
--

"Eric Rodriguez" Eric wrote in
message
...
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.