Form Button Opens as DataSheet not PivotTable

[mark.wolven]

I've made a form and added buttons to open 2 queries and 1 form. The
form opens perfectly.

I used the Command Button Wizard to create the button and selected the
Miscellaneous category to get to the Run Query action. The 2 queries
both open in datasheet view, and not in the PivotTable View which I've
formatted and set in the query as the Default View. How do I get the
button to open the query in the PivotTable View?

Also - the buttons are grey. I can change the color of the text, but
is it possible to change the color of the button background?

 

[mark.wolven]

I've made a form and added buttons to open 2 queries and 1 form. The
form opens perfectly.

I used the Command Button Wizard to create the button and selected the
Miscellaneous category to get to the Run Query action. The 2 queries
both open in datasheet view, and not in the PivotTable View which I've
formatted and set in the query as the Default View. How do I get the
button to open the query in the PivotTable View?

Also - the buttons are grey. I can change the color of the text, but
is it possible to change the color of the button background?

Nevermind, I just made a form display the Pivot Table view. Problem
solved.