I am trying to create a main report with 4 quadrants. Each quadrant should contain a subreport displaying a graph. The subreports are all built. Here’s the problem:
My users would like to be able to select which graphs show up on the report (there are 7 possible selections) and their quadrant location.
My idea is to create a form with combo boxes where the user can make the chart selections for each quadrant. After some research I believe it should be possible using VBA to use these selections to set each subreport’s source object.
But I don’t understand the necessary syntax and Help was not very helpful. If someone has or could create a simple working example I would be grateful.
Any help is appreciated.
My users would like to be able to select which graphs show up on the report (there are 7 possible selections) and their quadrant location.
My idea is to create a form with combo boxes where the user can make the chart selections for each quadrant. After some research I believe it should be possible using VBA to use these selections to set each subreport’s source object.
But I don’t understand the necessary syntax and Help was not very helpful. If someone has or could create a simple working example I would be grateful.
Any help is appreciated.
