Sorry, not gonna happen with acSelection. I'm not sure what is the course of action to be able to do what you are wanting. Perhaps openi the subreport by itself and pass it the main form criteria??? I don't know.
Sorry, not gonna happen with acSelection. I'm not sure what is the course of action to be able to do what you are wanting. Perhaps openi the subreport by itself and pass it the main form criteria??? I don't know.
How do I pass the main form criteria? Basically I think I am going to have to create a seperate form with all the options that are available on the pivotchart (e.g Textbox to put axis title, checkboxes for which fields etc..) Then the user can click a button to update the subform PivotChart from these criteria. Once they have the chart looking sweet they can press another button that opens a report containing the pivot chart and update it with the criteria. Then printout or save to JPEG.
What a lot of work......I was trying to avoid this by simply printing out the subform PivotChart from the original form.
No Spent, that would be silly. You could have the user pivot the chart in the subform then click the print or save button which assigns all the chart properties to variables and passes them to the Pivot Chart report for printout.