Others

How to Fix the Enter Parameter Value Prompt in Access

Steven ParkerSteven Parker Oct 29, 2026 873 views

Question details

The user is encountering an unexpected 'Enter Parameter Value' dialog box when running a query, which is asking for an obsolete field name.

How to Fix the Enter Parameter Value Prompt for Missing Fields in Access
Product
Microsoft Access 2019
Device & OS
not provided
Scenario
Running a query or accessing a database object after updating database terminology and renaming a field from CRQ to RITM.
Observed behavior
Access displays a prompt to enter a parameter value for a specific field (e.g., qryAssetRITMs.CRQ_No) because it can no longer find the old field name in the underlying tables or query structure.
Before you start

Before modifying your queries, identify the exact names of the newly updated fields and create a backup of your Access database to prevent accidental data loss.

Solution 1Recommended

Inspect and Update the Query Design

Run the affected query directly to isolate the issue, then use Design View to locate and replace the obsolete field references.

When a field is renamed in a table, Access queries that explicitly reference the old name will fail to find it. Access interprets the missing field as a parameter, prompting the user for input. Updating the query design resolves this missing reference.

1
Run the query independently

Open the Navigation Pane on the left side of the Access window. Locate the specific query causing the issue (e.g., qryAssetRITMs) and double-click it. If the parameter prompt appears here, the issue is directly within the query itself.

2
Open Design View

Right-click the query in the Navigation Pane and select 'Design View' from the context menu.

3
Check the query grid criteria

Look at the columns in the query design grid at the bottom. Inspect the 'Field', 'Criteria', 'Sort', and 'Update To' rows for any mention of the obsolete field name (e.g., CRQ_No).

4
Verify table joins

In the upper section of the Design View showing the tables, double-click the join lines connecting the tables to ensure they are using the correct, updated field names (e.g., RITM_No) rather than the old ones.

5
Replace and save

Delete the old field references in the grid and replace them with the correct field names. Click the 'Save' icon in the Quick Access Toolbar, then switch to 'Datasheet View' to confirm the query runs without prompting.

Inspect and Update the Query Design
Check Forms and Reports: If the query runs correctly on its own but you still get a prompt when opening a specific Form or Report, you must open that Form/Report in Design View and update its Control Sources and Record Source to match the new field names.
Free Microsoft Office alternative

Looking for a Free Alternative to Microsoft Office?

If you are working with spreadsheets, documents, and presentations and need a cost-effective alternative to Microsoft Office, WPS Office offers a powerful, free, and fully compatible suite for your daily productivity needs.

  1. 1. Download the software: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open your files: Launch WPS Office and directly open your existing Excel, Word, or PowerPoint files without needing to convert them.
  3. 3. Start working seamlessly: Enjoy editing, formatting, and analyzing your data using an intuitive interface equipped with advanced productivity tools.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsLightweight installation that takes up minimal system resourcesFamiliar user interface ensuring a seamless migration with zero learning curveFree to use for standard daily office and data analysis tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access randomly ask for a parameter value?

This prompt happens when Access is instructed to retrieve data for a query, form, or report but cannot locate a referenced field or table. It assumes the missing reference is a parameter and prompts you to provide a value manually. It is most commonly caused by typos in field names or referencing a field that has been deleted or renamed.

How can I find exactly which form or report is causing the parameter prompt?

Open the suspected form or report in Design View. Check the Record Source property in the Property Sheet. Next, verify the Control Source property for all text boxes, list boxes, and combo boxes. Also, review the 'Filter' and 'Order By' properties, as an obsolete field name there will also trigger the prompt.

Can I use the Database Documenter to locate missing field references?

Yes. You can go to the Database Tools tab and run the Database Documenter. Select the objects you want to analyze and generate the report. Once the report is generated, export it to a PDF or Word file and use the 'Find' function (Ctrl + F) to search the entire document for the obsolete field name.

Will fixing the query automatically fix my related forms and reports?

Not necessarily. If a form or report uses the fixed query as its Record Source, it will pull the correct data. However, if any controls (like text boxes) on that form or report are still bound to the old field name in their 'Control Source' property, the parameter prompt will still appear until those specific controls are updated.