How to prevent query opening in maximum.

[JOWINO]

I have set my main form to Maximize On Activate.
I have set the forms to Pop Up Yes
Now I have issues with opening the queries, The queries are maximizing
forcing me to close the entire database and open again.
Kindly how can I sort this?

 

[Gasman]

Size your queries when you create them.
Then they will open to that size.

Try resizing one to see it happen.

 

[arnelgp]

using DoCmd.Maximize, will affect all "windows" you open and will open maximized.

it is better to use DoCmd.Move

 

[RonPaii]

Your users should NEVER see naked queries. You have no way of preventing them from deleting or modifying data.

The only time I open a naked query for a user is for a quick copy and paste and then only in read-only mode.