You cannot have a query try to retrieve criteria from a report that uses that same query as its record source because, as you guessed, the query needs the criteria before the report is opened. You will need to supply the criteria some other way, like in a form - which is what one would normally do - then open the report.