Opening Pivot (2003 (SP2))

[Egg 'n' Bacon]

This may seem a silly request, but can anyone tell me how a pivot table form (or query) can be opened so it displays as a pivot table, from a button on another form?

I've tried setting the default views to 'pivot table' but a form opens as a form & a query as a datasheet.

[HansV]

Use an instruction such as

DoCmd.OpenForm "frmOrders", acFormPivotTable

The second argument tells Access to open the form as a pivot table. If you omit this argument, the form will be opened in form view. It's similar for queries.

[Egg 'n' Bacon]

That's done it.

Many thanks