Select Query to Open on Top of Form

[Guest]

I have a form [Grievance Tracking] that has a command button for a select
query [GTS Audit]. When the user selects this button the query opens behind
the form [Grievance Tracking]. Is there a way to have the query open on top
of the form [Grievance Tracking] form instead of behind it?

I'm using Access 2003.

Thanks,

 

[Guest]

The problem is that the form PopUp Property set to yes, so every thing that
you open will apear behind it.

You can set it to No, and then the query will be on top of the form

 

[Guest]

Ofer's idea is good.
It may look better if you create a subform on your form and make the
subform's record source the query.