- Local time
- Today, 23:40
- Joined
- Sep 12, 2006
- Messages
- 15,672
the trouble is that if you do this
then the report will print before the date range gets populated, and you will probably get an error. as well
One way is to have the report date range built into the query (it will appear the same on every row) and then you can just bind the query field to the report control to fill the dates.
Code:
DoCmd.OpenReport "RptSummary_Report", acPrint 'not sure about the syntax
Report_RptSummary_Report.txtStart_Date = FiltStartDate
Report_RptSummary_Report.txtEnd_Date = FiltEndDate
then the report will print before the date range gets populated, and you will probably get an error. as well
One way is to have the report date range built into the query (it will appear the same on every row) and then you can just bind the query field to the report control to fill the dates.