How to supress multiple user prompts in MS Access 2007

[Roopa_talla]

Hi ,



I have a query which needs input of date.
When we open the report the query is executed and displays the details.

This query is repeated each time for a single report based on number of databases.

The problem is the user input pop up window for date pops up each time the query is executed.

I want the prompt to be asked only 1 time and take the same input wht ever is entered for the report .

The user entry is designed in a form. The control is unbound.
The where clause in the query is -
WHERE P_BUSINESS_DATE=[Enter Business Date dd/mm/yyyy] .

Can anyone please help with the solution .
I wld be very thankful.

Regards,
Roopa.

[pbaldy]

The most common solution is to have the user enter the date in a form, then have the query get the value from there:

WHERE P_BUSINESS_DATE = Forms!FormName.TextboxName