queries opening on top of call form

[YPMA]

As a user of access 2003 for many years I am testing out access 2013. In access 2003 , when opening a query from a forms command button the query appears on top of the form for easy reading. In Access 2013 the query opens under the calling form and to read it I have to minimise the form and then restore. My users would find that too difficult. I would prefer not to have to create a form or report as there are many queries in my current database. As said earlier it worked fine in Access 2003 so what different ? and is there a way round it?

[twinnyfo]

Is your form in Modal/Pop-up mode? this would place it on top of the resulting query.

I know there are all sorts of preferences out there for display of information, but I have always been one who is hesitant to display a raw query, as it can open the door to people intentionally or inadvertently making changes to those queries. However, some prefer to allow that view, which is neither right nor wrong, just different.

:-)

[YPMA]

Twinnyfo Thank you for replying to my question, yes the call form is a popup but not modal. I made it a non-popup and you are correct the query was placed on top. These queries are management non updatable queries. So thanks again for your input it gives me and option, I do like the Popup as the form looks good as appose to filling the whole screen. .

[jforbes]

Being new to Access 2013, you may want to look at the Tabbed Documents verses Overlapping Windows option. It's an option that is available to you now that sounds like you will probably not use, but it seems worth mentioning.

It's located at File|Options|Current Database| Document Window Options

[YPMA]

jforbes Thank you. It solved my worry about forms looking good.
I don,t know the pro and cons of using the Tabbed Document verses Overlapping windows which was the default. I now will now to try and understand' "My Access 2013 the missing manual" arrives tomorrow.

Regards Ypma