Mar 30, 2011 #1 TimPen Technical User Mar 28, 2011 41 ZA I open a form as a pivot table using: DoCmd.OpenForm "frmDataAnalsysPivotTable", acFormPivotTable How can I get the form header and footer to display? In the header I want to add a check box to turn the ShowPivotTableFieldList on/off. How do I do this?
I open a form as a pivot table using: DoCmd.OpenForm "frmDataAnalsysPivotTable", acFormPivotTable How can I get the form header and footer to display? In the header I want to add a check box to turn the ShowPivotTableFieldList on/off. How do I do this?