Opening PivotTable form 1

[topgeek]

I've created a PivotTable on a form and when I open the form from within Access by double-clicking on it opens fine and displays as expected.

However, when I use a command button (generated by the command butrton wizard to open the form, I just get a single row display of the fields used for the pivottable.

Has anyione any idea what the problem is???

 

[PHV]

Take a look at the 2nd argument of the DoCmd.OpenForm method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[topgeek]

Thanks PHV,

That was spot on - hadn't even realised there was particular argument for a Pivot Table!!