What happens when you run the query? If it opens OK, then the problem (as ranman256 pointed out) is likely there. If not, it's likely in the report. You might have, for example, renamed or mis-spelled a report control, or altered it's record source. The prompt you're getting is likely a parameter prompt. The message tells you what it's looking for or can't resolve. The only other thing I can think of that can (rarely) cause this is when Access can't distinguish between the name used for a control and the name of the field it's bound to because they have the same name.
Last edited by Micron; 03-10-2017 at 10:12 PM.
Reason: spelin
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.