Enter values once for multiple queries

[Guest]

I have a report and use two queries as subreports. The queries are setup
to ask for start date and end date parameter info. When I run the report, I
am prompted twice to enter the same info for each subreport. I only want to
be prompted once and use those values for both subreports.
I was recently getting help from John Vinson, but our efforts have
stalled. I created a separate pop-up form with two unbound text boxes to
enter the start and end dates for my queries. I am wondering if there is a
way to link those values in the form to the two queries.
Maybe have the text boxes bound to a small table that saves the date
entries and tell the queries to use the last saved record entry? I don't know
how to put this together.

 

[Jeff L]

You don't need to store the values. Using textboxes on your form
should work fine. In the criteria of your reports, you would refer to
the boxes on your form like this:
Forms!YourFormName!StartDate
And
Forms!YourFormName!EndDate

The form needs to be open for this to work properly.

Hope that helps!

 

[Duane Hookom]

You must have the form open and dates entered into the text boxes. Then you
set the criteria in your report and/or subreport Record Sources to something
like:

Between Forms!frmYourName!txtStartDate and Forms!frmYourName!txtEndDate

If this doesn't work, you need to tell us what you tried and what results
you saw.