Fix Microsoft Access Form Parameter Prompts for Deleted Fields
Question details
Find and remove references to deleted fields that cause parameter prompts when an Access form opens.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A form or subform uses a table or query from which fields have been deleted.
- Observed behavior
- Access displays an Enter Parameter Value prompt because a form, query, control, filter, or event may still reference a deleted field.
Note the exact name shown in the Enter Parameter Value prompt and check whether it is a deleted field or an intentional query parameter. Identify the form and any subforms or queries that use the affected table.
Remove deleted-field references from the form and its sources
Use Design View to locate the field name in form properties, controls, queries, and event code.
In the Navigation Pane, right-click the form and choose Design View. Open each affected subform in Design View as well, then press F4 to open its Property Sheet.
In the Property Sheet, inspect the form's Record Source, Filter, and Order By properties. Select each control and check its Control Source, calculated expressions, and any Row Source for the field name shown in the prompt. Update or remove obsolete references.
In the main form's Design View, select the subform control and inspect its Link Master Fields and Link Child Fields properties. Replace or remove deleted-field references while keeping the intended relationship between the forms.
Open each query used by the form or subform in Design View. Check selected fields, calculated expressions, criteria, sorting, and joins for the deleted field; update or remove references and save the query.
Check relevant form and control events in the Property Sheet's Event tab. Open associated VBA code, use Edit > Find to search for the field name, and update any references. In the VBA editor, choose Debug > Compile, save your changes, and reopen the form to test it.

Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations, with a familiar interface and support for common Microsoft Office formats to ease migration. It does not repair Access databases or replace Access form design.

Frequently Asked Questions
Why does Access ask for a field that I deleted?
Access may interpret an unresolved field reference as a parameter. Check the form's Record Source, control properties, filters, and underlying queries for the name shown in the prompt.
How do I check whether a subform is causing the prompt?
Open the subform directly from the Navigation Pane in Form View. If it prompts, open it in Design View and inspect its properties and source query. Also check Link Master Fields and Link Child Fields on the subform control in the main form.
Where can I find a deleted field in a query?
Right-click the query in the Navigation Pane and select Design View. Look for the field in the design grid, calculated expressions, criteria, sorting, and joins.
Should I remove every parameter prompt?
No. Some queries intentionally request a value. Check the prompt name and the query's criteria before changing it; remove or update the reference only if it is obsolete or incorrect.




