samuelimtech
09-15-2015, 02:33 AM
Hi all,
really bugging me that nothing seems to work here.
all I want to do is hide the details in a pivot using VBA, please see the string below and although its incorrect it should be pretty obvious what im trying to do
[Forms]![Admin_Form V2].PivotTables("Import_Pivot").PivotField("Alpha Name").ShowDetail = False
thanks
really bugging me that nothing seems to work here.
all I want to do is hide the details in a pivot using VBA, please see the string below and although its incorrect it should be pretty obvious what im trying to do
[Forms]![Admin_Form V2].PivotTables("Import_Pivot").PivotField("Alpha Name").ShowDetail = False
thanks