I think this is quite complicated and I suspect there might not be a good answer to it.
I have a report which has subreports which are not pre-determined, but rather sourced from a table when the report is opened using VBA code. This normally works fine.
I now need to open my main report in multiple instances, so rather than using DoCmd.OpenReport to open it I have to dimension a rpt variable and set it to the report class, and then set the variable's visible property to true.
This method for opening reports works fine for simple reports, but when I try it even for a single instance of my report it errors, saying that I can't set a subreport's SourceObject property in Print Preview or after printing has started.
I don't know what the difference between using DoCmd and the variable method is, but it is certainly causing the problem. Anyone have any detailed knowledge on this?
Sam.
I have a report which has subreports which are not pre-determined, but rather sourced from a table when the report is opened using VBA code. This normally works fine.
I now need to open my main report in multiple instances, so rather than using DoCmd.OpenReport to open it I have to dimension a rpt variable and set it to the report class, and then set the variable's visible property to true.
This method for opening reports works fine for simple reports, but when I try it even for a single instance of my report it errors, saying that I can't set a subreport's SourceObject property in Print Preview or after printing has started.
I don't know what the difference between using DoCmd and the variable method is, but it is certainly causing the problem. Anyone have any detailed knowledge on this?
Sam.
