Form Button Opens as DataSheet not PivotTable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mark.wolven@gmail.com - 01 Apr 2008 15:37 GMT

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?

Reply to this Message

mark.wolven@gmail.com - 01 Apr 2008 15:54 GMT

On Apr 1, 10:37 am, mark.wol...@gmail.com wrote:

> I've made a form and added buttons to open 2 queries and 1 form. The
> form opens perfectly.
[quoted text clipped - 7 lines]
> 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.

Reply to this Message