Date Range Parameter help!?!?

[dkstech]

I am a newbie to access and ran across a problem. I have a reporting db that pulls info from another db, most of the functionality works but there are some qwerks and this is one of them.



I start by clicking a button to run a report. The report asks me for a manager code, Start Date and End Date then generates the report seemingly fine. It is generally a 150 page report. The issue is printing it or going between pages, every page it prints it asks for the Start Date and End Date again and again. Sames goes if you just click to the next page. I narrowed it down to the sub report, then the query that actually asks for the parameters

If it uses this in the criteria, letting the user choose the dates:

Between [Start Date] And [End Date]

No matter what date I enter it has the crazy problem of asking for every page. If I change the it to a specific date range.

Between #10/1/2010# And #10/31/2010#

Which is exactly the same as what I put in the prompt it works fine..... Does not ask me any questions, just runs the report AOK and I can flip through the pages and print them all if i feel like.

So what is going on with this?

[NTC]

why that query is firing with each page - I'm not sure. But in any case it is - so the fix is to put those 2 dates into an open form in two separate unbound text boxes. stylistically you can decide how best to do that in terms of the user experience.

then modify that query so instead of a prompt - it is calling the value(s) from that open form's controls.

hope this helps.