Course summary: Stop a query from asking for input

In desktop databases and Access web apps

  1. With the query in Design view, click Parameters (Design tab),

  2. Delete the parameter, click OK.

  3. Delete the parameter from the Criteria row.

  4. 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.

See also

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.