I have a macro that opens and prints out two sets of documents. First it uses OpenReport:
[IndustryList]![Industry]=[Forms]![IndustryTemplate]![Industry]
to open a one/two page report on an Industry specified by the user.
Then it uses PrintOut to print out the one/two page Industry Report.
I then have another OpenReport that I want to use to print out the CapitalIQ Reports on ALL (from 5-20) Companies that are mentioned in the Industry Report. I currently have:
[CapitalIQ]![CapitalIQTicker]=[Reports]![Industry Report]![CapitalIQTicker]
however the above code for OpenReport only prints out the CapitalIQ report for the LAST Company mentioned on the Industry report.
Is there a way to get the macro to print out the CapitalIQ reports for ALL the Companies on the Industry Report.
Thanks,
Sam
[IndustryList]![Industry]=[Forms]![IndustryTemplate]![Industry]
to open a one/two page report on an Industry specified by the user.
Then it uses PrintOut to print out the one/two page Industry Report.
I then have another OpenReport that I want to use to print out the CapitalIQ Reports on ALL (from 5-20) Companies that are mentioned in the Industry Report. I currently have:
[CapitalIQ]![CapitalIQTicker]=[Reports]![Industry Report]![CapitalIQTicker]
however the above code for OpenReport only prints out the CapitalIQ report for the LAST Company mentioned on the Industry report.
Is there a way to get the macro to print out the CapitalIQ reports for ALL the Companies on the Industry Report.
Thanks,
Sam
