Fix Microsoft Access Query Asking for a Date Parameter Twice
Question details
The user needs an Access query to request a date once and use it consistently.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Running a query that uses an entered date as a parameter.
- Observed behavior
- Access prompts for the same date twice; unresolved or inconsistent references, date interpretation, or a query issue may be involved.
Identify the query that produces the prompts and note the exact text shown in each prompt. Check which date field the query filters and whether a form is already supplying the date.
Use an Unbound Form and Declare the Date Parameter
Use a form to collect and validate the date once, then reference that control consistently in the query.
In Access, select Create > Form Design. Add an unbound text box named txtDate and save the form as frmDate.
Add a button to frmDate and use its Click event to check that txtDate contains a valid date before opening the query. If the value is blank or invalid, display a message and keep the form open.
Open the query in Design View. In the Criteria row under the date field, enter [Forms]![frmDate]![txtDate]. Use that exact reference wherever the same date is needed.
In Query Design, select Parameters. Enter [Forms]![frmDate]![txtDate] as the parameter name and choose Date/Time as its data type, then save the query.
Open frmDate, enter a valid date in txtDate, and run the query while the form remains open. Confirm that Access uses the entered date without asking for it again.
Check Query References and Test a Copy
Use this approach if duplicate prompts continue or appear unexpectedly in an existing query.
Work With Office Documents in WPS Office
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support help you move existing files into your workflow. It does not repair Microsoft Access queries or replace an Access database.

Frequently Asked Questions
Why does Access show a field or control name in a parameter prompt?
Access may be unable to resolve that name. Open the query in Design View and check the spelling of the field, form, and control references. If the reference points to a form control, make sure the form is open.
How do I declare a date parameter in Access?
Open the query in Design View, select Parameters, enter the exact parameter name or form control reference used in the query, and set its data type to Date/Time.
Can regional date formats affect an Access query?
Yes. Ambiguous date text can be interpreted incorrectly. Declare the parameter as Date/Time and validate the value entered on the form before running the query.
What if a copied query no longer prompts twice?
Compare the copy with the original in Design View and test both with the same date. A copy may behave differently because of a query or application issue, but the result alone does not establish the cause.




