Repetitive pop up criteria window

[Guest]

Hi
In a query based on my orders table i have a Between ... and ... on a date
field.
I have created a report based on a customer table then a report based on an
orders table. I have included my report on orders table in my report based on
my customer table as a subreport.
When launching my report customer it asks me the date for every customer ?
Could you tell me why ?
Please a solution ..
Thxs
Didier

 

[PC Datasheet]

You get this because the criteria in your query is not available when the
query is called. Look at the sequence of events when the report opens and
see if the criteria in the query is available when your subreport opens.

 

[Duane Hookom]

Stop using parameter prompts in your queries. Use references to values of
Controls on Forms. This is much more powerful, flexible, and professional.

Here is one resource on how this can be done
http://www.fontstuff.com/access/acctut08.htm