I am loading a pivot form, from a form, and would like it to load in pivot chart view, rather than pivot table view. All I can find is the code below, but I am unable to make the necessary changes for this code to work.
Can anybody help with this? Thank you!
Forms(0).AllowPivotTableView = True
DoCmd.OpenForm FormName:=Forms(0).Name, view:=acFormPivotTable
Can anybody help with this? Thank you!
Forms(0).AllowPivotTableView = True
DoCmd.OpenForm FormName:=Forms(0).Name, view:=acFormPivotTable