Report and Subreport with Date Range Criteria

[lucky33]

I am working on a project that has a report with a subreport. However
both of these run off of a query that has a criteria for date range
for the data. When I run the report I have to enter the beginning and
ending date twice. Is it possible for me to set this up where I only
have to enter the date range once and it apply to both the report and
sub report???

All help is greatly appreciated.

 

[Duane Hookom]

IMHO, parameter prompts aren't generally appropriate user interface. Use
controls on forms for all criteria entry.

 

[lucky33]

IMHO, parameter prompts aren't generally appropriate user interface. Use
controls on forms for all criteria entry.

Can you explain how I would do that? Not very familiar with what you
are talking about

 

[Duane Hookom]

You create a form with a couple text boxes and a command button that opens
the report. Assume frmDates with text boxes txtStartDate and txtEndDate.
You would remove the parameter prompts and replace them with:

Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate

 

[lucky33]

You create a form with a couple text boxes and a command button that opens
the report. Assume frmDates with text boxes txtStartDate and txtEndDate.
You would remove the parameter prompts and replace them with:

Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate

--
Duane Hookom
Microsoft Access MVP






- Show quoted text -

Thank you very much