Question Open Query infront of other tabbed forms

[mm07nkb]

Hello -

I have an Access 2007 application with mutiple forms, etc that my user will interact with. Upon clicking a particular button, I have put the VBA code docmd.openquery "query1" that works fine, however it opens the query on a tab behind all of my forms and I need it to open on top of the application so that my end-user can see it.

Is there a way to open the query in its own window and bring it to the front or set the focus so that it pops-up on top of my forms?

Any ideas are much appreciated!

 

[Beetle]

See my reply in your other thread, and please don't double post. It duplicates the efforts of the people who volunteer their time here.