Muliple Parameter Queries Identical Parameter Values using DAP

[Katherine Bunney]

Hi,

I have two parametric queries running on a single data access page
that both prompt me for a date range as I start up the page. Seeing as
the user entered date range will always be the same for both queries
is there any way to enter the date range once and parse these values
onto both queries?

I have found the answer to this type of problem when one is making use
of normal reports but have been unsuccessful in finding the equivalent
for DAP.

Thanks

 

[Guest]

Use a form with unbound text boxes to enter the data.
Then in the criteria reference the text boxes this way --
[Form]![YourFormName]![TextBoxName]