I get prompted for a parameter when I don't expect it.

If you get prompted to type parameters when you attempt to run a query, report, or data access page, and you don't expect this prompt, one of the following might apply:

• You deleted a parameter from the query design grid but not from the Query Parameters dialog box.
  
  
• You renamed or misspelled a field in the query, report, or data access page but not in the query's underlying table(s).
  
  
• You have a field that refers to a calculated field. If a field in the query performs a calculation based on the calculated value, make sure the Show check box is checked for the calculated field in the query design grid.