Mystery Prompts?

[JoeyB_99]

I am currently using Access 2007 and have an inherited a database with an unusual problem.

When I run a report I receive an unusal prompt. This is weird because the query driving this report does not give this prompt when it is run by itself!

Also, when I simply click on this prompt with no input, the report runs fine. No problems with the output.

However, this query has three queries preceding it. That is, they feed into each other. And when I run each of them separately I do not receive this mystery prompt.

All queries have been designed without prompts. No input prompts are required to run any of the queries or the report.

The prompt partially identitifes itself as, "Query2.field". None of the queries involved here, nor any other queries in the database are named Query2! I'm assuming this means the second query of this query chain. Does that make sense?

I'm not sure what else to provide for help in trouble-shooting this. I've carefully reviewed each query and it's output and can't see a problem.

Any help - even general in nature - would be greatly appreciated.

 

[pr2-eugin]

A prompt would normally occur when the Query is executing and finds that there is no such Field or criteria present at all.

Sometimes when you are accessing Form based Queries as Forms![FormName]![FieldName] if you are running the Query on its own then a prompt for Forms![FormName]![FieldName] will ba given to enter the value.

Some tips: (not sure if they are relevant or helpful in that matter)
* Make sure that the Query2 is not hidden
* Check the query in SQL view to see if you can find the mystery field.

 

[robina]

Another place to check is in the row source on any forms associated with the report. Since this is an area where you create a query on the fly by do not need to give it a name, this could be a source of what is requesting input.

 

[Galaxiom]

Sometimes things go wrong when changing names of fields and queries causing corruption.

I have seen queries where both the Design View and the SQL View look perfect yet they prompt for a "missing" parameter when run.

Copy the SQL text from each query, paste it into a new query. Delete the old query and save the new one with the original name.

Important: Don't change the name of the old query unless you have NameAutoCorrect turned off or the change will propogate through to the dependent objects.