Select Query to Open on Top of Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rdw1260@msn.com.(donotspam) - 14 May 2007 19:34 GMT

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,

Signature

Bob

Reply to this Message

Ofer Cohen - 14 May 2007 19:51 GMT

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

Signature

Good Luck
BS"D

> 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
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message

Klatuu - 14 May 2007 22:40 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message