P
prodeji
Hi all
I have a report that runs on a query (duh) .
I set up a combo box on a form to select these parameters.
The code of the "OK" button includes a DoCmd.OpenReport so it'll go
straight to the report rather than runnin the query and then including
an event trigger to run the report once the query has been run (or
something like that).
However, when the report is run, the (2) subreports give a "#Name"
error.
I gather so far that this basically means Access can't find the object
it generates this error for.
When I did it the tacky way originally (run query then some trigger to
run the report) the subreports displayed fine.
How can I run the report straight from the OK button's code
(DoCmd.OpenReport) without generating the "#Name" errors?
Thanks for any help
prodeji
I have a report that runs on a query (duh) .
I set up a combo box on a form to select these parameters.
The code of the "OK" button includes a DoCmd.OpenReport so it'll go
straight to the report rather than runnin the query and then including
an event trigger to run the report once the query has been run (or
something like that).
However, when the report is run, the (2) subreports give a "#Name"
error.
I gather so far that this basically means Access can't find the object
it generates this error for.
When I did it the tacky way originally (run query then some trigger to
run the report) the subreports displayed fine.
How can I run the report straight from the OK button's code
(DoCmd.OpenReport) without generating the "#Name" errors?
Thanks for any help
prodeji