Report

[halabis]

I have created a report that pulls 3 values from a query: AgentName, ReviewDate, and SumO. The query itself is filtered by value "Manager" from a dropdown in a subform.

Running the report (either through the subform or manually) works fine. However each time I also get pop ups asking me to enter the values ODate & 6Month.

Neither of these values are in the query being pulled.

However the query does pull from another query that has both of those values. I'm just hitting enter and leaving the two pop ups blank, and the report is pulling up just fine.

What do I need to do to make those pop ups stop?

The report is coming out looking fine, it is just looking for more data than I need it to. (Those values in the pop up are used to calculate SumO, and SumO is calculating perfectly fine without me entering anything into them)

[ranman256]

You get popups in queries if:
1. the field does not exist
2. the field is spelled wrong (same as 1)
3. a reference to external table or form is incorrect

in a report
a group does not exist

a field does not exist...now, if you do math in a text box, be sure to use the text box NAME and not the field.
if a box formula = rate * qty
these are the field names, but the box name is txtRate that uses the field Rate
then it must be: = txtRate * Qty

[halabis]

You get popups in queries if:
1. the field does not exist
2. the field is spelled wrong (same as 1)
3. a reference to external table or form is incorrect

in a report
a group does not exist

a field does not exist...now, if you do math in a text box, be sure to use the text box NAME and not the field.
if a box formula = rate * qty
these are the field names, but the box name is txtRate that uses the field Rate
then it must be: = txtRate * Qty

On further review the popups only appear when i run the report. The report itself only has 3 fields, and none of them are of the two popups. Those two popups are fro fields that don't even appear in the query being pulled, and the report itself is not asking them to be pulled.