M
MartyO
Hi there. I'm having a problem getting a header to show up on a Pivot Chart
form.
I have a criteria form where the user chooses a Campus from a drop down
Combo box, and they choose a report or form(Pivot Chart) from an option
group, then click on the button to open the form or print preview a report.
The Pivot Chart then filters based on the campus chosen in the drop down. I
simply want to pass the campus name to a text box in the form header, by
setting the contol source to referrence the drop down on the criteria form.,
i.e., the control source is
=[Forms]![frmSwbrdReportCriteria]![cmbSelectCampus].
Nothing in the form header band of the form shows up when you view the form.
If I take this same form and use it as a subform, and put this header on the
parent form the header with the campus shows up... but I don't want to do it
this way because it renders the pivot chart differently when you view it,
it's not in porportion to the window it's in.
I also tried using VBA to do this by setting the property when the form
opens but again, nothing in the from header area will show up when you view
it. Not even text typed straight into it.
Can you not put a header on a Pivot Chart Form? or How can you set the Chart
caption property setting... I tried me.caption = strReportHeader when the
form opens and that doesn't work either.
Help!
Thanks in advance!!
Marty
form.
I have a criteria form where the user chooses a Campus from a drop down
Combo box, and they choose a report or form(Pivot Chart) from an option
group, then click on the button to open the form or print preview a report.
The Pivot Chart then filters based on the campus chosen in the drop down. I
simply want to pass the campus name to a text box in the form header, by
setting the contol source to referrence the drop down on the criteria form.,
i.e., the control source is
=[Forms]![frmSwbrdReportCriteria]![cmbSelectCampus].
Nothing in the form header band of the form shows up when you view the form.
If I take this same form and use it as a subform, and put this header on the
parent form the header with the campus shows up... but I don't want to do it
this way because it renders the pivot chart differently when you view it,
it's not in porportion to the window it's in.
I also tried using VBA to do this by setting the property when the form
opens but again, nothing in the from header area will show up when you view
it. Not even text typed straight into it.
Can you not put a header on a Pivot Chart Form? or How can you set the Chart
caption property setting... I tried me.caption = strReportHeader when the
form opens and that doesn't work either.
Help!
Thanks in advance!!
Marty