Passing criteria into a report from a form
Posted on 2013-11-27
I have a query (qry_report1) and a report (rpt_report1) that requires 2 inputs from the user - StartDate and EndDate. I have set up a form (frm_report) with 2 txt fields with datepickers where the user can set the dates. I have made a command button calling the report using DoCmd.OpenReport.
When I open frm_report and set the dates and press the button the setup works, but when I embed the frm_report in a navigationalform (frm_menu) and run it from here it doesn't work anymore. Instead I keep getting the enter parameter value dialogue box.
Whats the problem?