Report and Subreport with Date Range Criteria

  • Thread starter Thread starter lucky33
  • Start date Start date
L

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.
 
IMHO, parameter prompts aren't generally appropriate user interface. Use
controls on forms for all criteria entry.
 
IMHO, parameter prompts aren't generally appropriate user interface. Use
controls on forms for all criteria entry.
Click to expand...
Can you explain how I would do that? Not very familiar with what you
are talking about
 
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
 
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 -
Click to expand...

Thank you very much
 
Back
Top