I am trying to build a report that uses a crosstab query as its data source. The crosstab query has three input parameters and functions as expected by itself. My problem is when I attempt to connect the query to my report, the report behaves as if I am not passing the parameters. The default parameter dialog box keeps appearing - three times, once for each parameter. My three parameters are: Factory, Year, Month. My VBA code looks like below:
DoCmd.OpenReport "SHByFactoryDetail", acPreview, "Factory=''3M'', Year=2011, Month=12
It just ignores the parmeters that I provide above and asks me to re-enter the parameters again via the default parameter dialog box.
How can I fix this?