Course summary: Stop a query from asking for input
In desktop databases and Access Apps
With the query in Design view, click Parameters (Design tab),
Delete the parameter, click OK.
Delete the parameter from the Criteria row.
Save and run the query.
Note You may not find parameters in the Query Parameters dialog (steps 1-2), but check to be sure. For an Access App, you’ll probably want to delete the associated views and macro, too.
In a Union query
Delete the clauses after each FROM statement: WHERE [field name] = [your parameter]. Delete both clauses or Access will display a dialog.
In an expression
Look for and fix any typos in field names (the most common problem). If they aren’t the problem, follow the links to articles about expressions.