Form overlapping query

[Sue22]

Hi I have a form which is the main menu for my database and on it there are some options to run queries but the queries always end up hidden behind the form when they run Can anyone help me with what I do so that the queries come out on top of the form not behind it??

Thanks in anticipation.

 

[BlueIshDan]

So it does open a window with your results, but that window is behind the main form?

 

[BlueIshDan]

Make sure your main form isn't Modal. This option can be found in the "Other" properties tab of your Form Properties menu.


Be sure your code to open the query is something like this.
If your query is not a saved queryDef, replace the "qryQueryName" with your query string.

DoCmd.OpenQuery "qryQueryName", acViewNormal, acReadOnly

Other modes are acAdd, acEdit, acReadOnly

 

[Sue22]

The command to open the query is already:

DoCmd.OpenQuery "KIS Course List", acViewNormal, acReadOnly

Main Menu is currently modal = No

the query is sitting behind the form when it opens