How to Fix the Enter Parameter Value Prompt in Access
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.

- 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 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.
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.
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.
Right-click the query in the Navigation Pane and select 'Design View' from the context menu.
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).
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.
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.

Search for Obsolete Fields in VBA Code and Macros
Locate hardcoded field names inside VBA modules or Macros that trigger the parameter prompt during automated events.
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. Download the software: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open your files: Launch WPS Office and directly open your existing Excel, Word, or PowerPoint files without needing to convert them.
- 3. Start working seamlessly: Enjoy editing, formatting, and analyzing your data using an intuitive interface equipped with advanced productivity tools.

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.




