Pivot chart form help

[Smoothcat74]

Hi everyone,

I have created a pivot chart in my database to help users more easily analyze data. When this form loads, however, the pivot chart field list defaults to being not visible. Could someone let me know the command I can use in VBA to set the field list to visible when the form loads?

Thanks!

 

[dhookom]

Have you considered just linking to your Access tables/query from Excel? I much prefer the Excel interface for Pivot Tables.

Duane
Hook'D on Access
MS Access MVP

 

[Smoothcat74]

I would prefer to keep the application as self-contained as possible for ease-of-use, so any suggestions on manipulating the pivot chart via VBA would be extremely helpful.

 

[dhookom]

Try code in the On Open event of the form

Private Sub Form_Open(Cancel As Integer)
    Me.PivotTable.DisplayFieldList = True
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[Smoothcat74]

It doesn't recognize the "DisplayFieldList" property. Is there a reference I need to add before that is available?

 

[dhookom]

Are you viewing your form in PIVOT TABLE view or does your form contain a pivot table control or something? I don't generally display a form as a pivot table but the code works for me.

Duane
Hook'D on Access
MS Access MVP