Need Command Button to Pull Up A Pivot Table

J

jillian.calderon

I put a command button on the form and directed it to the pivot table I
created. I saved it and opened the form, but the command button doesn't
lead to the pivot table. How can I get the command button to open in
Pivot Table Form instead of just the form? Thanks! <3 Jill
 
M

maXim

goto the built event of the command button .i.e click event of the button
and add the
DoCmd.OpenForm "pivottable name",acFormPivotTable
dats it.
 
Top