Others

Fix Microsoft Access Query Asking for a Date Parameter Twice

Phi Hung VoPhi Hung Vo Nov 14, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create a date entry form

In Access, select Create > Form Design. Add an unbound text box named txtDate and save the form as frmDate.

2
Validate the entry

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.

3
Reference the form control

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.

4
Declare the parameter

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.

5
Run 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.

Keep the form open: Access must be able to resolve the form and control reference when the query runs. A closed form or a misspelled name can cause a parameter prompt.
Free Microsoft Office alternative

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.

Use a familiar interface for common office tasksOpen and edit Microsoft Word, Excel, and PowerPoint formatsReview date-based lists and reports in spreadsheetsMove existing supported Office files into a lightweight workspace
microsoft office alternative - wps office

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.