Form Button Opens as DataSheet not PivotTable

  • Thread starter Thread starter mark.wolven
  • Start date Start date
M

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?
 
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?
Click to expand...

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