Form.AllowPivotTableView Property (Access)
Returns or sets a Boolean indicating whether the specified form may be viewed in PivotTable View. True if PivotTable View is allowed. Read/write.
Syntax
expression .AllowPivotTableView
expression A variable that represents a Form object.
Remarks
Use the AllowDatasheetView , AllowFormView , AllowPivotChartView, or AllowPivotTableView properties to control which views are allowed for a form.
Example
The following example makes PivotTable View valid for the specified form and then opens the form in PivotTable View.
Forms(0).AllowPivotTableView = True
DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormPivotTable