Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display form in pivot chart view by default

Status
Not open for further replies.

dbero

Technical User
Mar 31, 2005
109
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top