Access 2007 VBA - Open report with filtering
Posted on 2011-02-11
This one should be quick and easy...
I've got a tabular report bound to a query. I need to open that report from a form where I select a projectID and a date range. In a button click event on the form I am able to open it using this...
DoCmd.OpenReport "rptExpenditureReport", acViewReport
But how do I pass parameters to the report and how do I utilize those parameters as filters?