How to add a Cmd button?

[Johnrg]

Hi All,

I have a form (OrdersPivotForm) and subform (OrdersPivot)

The record source of the subform is a query called OrderPivotQuery.

The subform dispalys in Pivot Table format, not Data sheet format.

I need to add a command button on the main form (OrderPivotForm) that exports/copies the query to Excel.

If I open the subform independentlly of the main form there is a microsoft Pivot Table "toolbar" Cmd button to do this and it works a treat. Excel opens with two sheets, one is the data from the query and the second is a pivot table based on that data.

So, how do I add a Cmd button to my main form that does the same thing (exports the subforms data to Excel as a pivot table)
Thanks

JohnG

 

[John Big Booty]

This link may help in formulating your command.