Button that makes you go to the query tool

[Dinictus]

Hi,

This looks like an easy one but I can;t figure it out.

I have a "main screen" for my dbase and on this screen I want a button that will make you go to the query tool.

Now with the button wizzard you get several options like: run macro, close application etc etc. But how do I make it go to the query tool.

(the button is on the toolbar by the way but I want to have in a form)

thanks.

 

[Pat Hartman]

I don't know the answer but I know where I would look. In any code module type: DoCmd.Runcommand followed by a space. You'll get an intellisense list. If you can open the querybuilder via code, it will be an option in this list.

 

[WayneRyan]

D,

Put this line of code on your Command Button:

docmd.OpenQuery "SomeQuery",acViewDesign

Wayne

 

[spacepro]

Try this:

DoCmd.RunCommand acCmdNewObjectQuery

Andy

 

[Debased]

Spacepro is an ACE-pro...that works perfect for me...always wondered how to do that. Thanks!

 

[spacepro]

Thanks Debased,

Glad to Help.

Good Luck

Andy

 

[Dinictus]

Spacepro,

That's truelly beautiful! It works.