Query opens maximized.

[froggiebeckie]

Greetings all.
I've got a minor housekeeping issue with my db that I can't seem to crack.

The db opens to the main form, which has a boat-load of control buttons that open a variety of forms and reports and 1 query.

The problem is that when you select the button that opens the simple query, the query opens in maximized view and then when folks want to close it, they often end up closing the whole db, instead of just the query. (Using the right corner X.)

I'd like to open it about half screen or so, to avoid the accidental closing of the whole database.

I can open the query directly or from the macro and in both instances it opens up the correct window size. But when I use the button it opens maximized.

I've searched the code, can't find any reference to maximize.
Can't find anything in the button properties that would cause it.

Any idea why this is happening or how to get around it? It's probably something simple, but then, so am I. (hehehehe)

Thanks,

BeckieO

 

[froggiebeckie]

Got IT!

Stumbled on the answer and thought maybe there is someone else (like me) who didn't know.

Added "Restore" command into Open Query macro that's attached to the button.


Thanks anyway.

BeckieO