Creating a blank query programatically

[bpaquette]

perused the vast access world threads for this answer, to no avail.

trying to simply create a blank query through access. i want the user to simply be able to click on a button and have a new blank query pop up.


there's gotta be a method to this.. anyone?

 

[Uncle Gizmo]

click on a button and have a new blank query pop up.

Do you mean you want the query design grid to pop up ?

 

[bpaquette]

exactly -- can it be done?

 

[dcx693]

This command:
DoCmd.RunCommand acCmdNewObjectQuery
will bring up the New Query window, but you must still tell it what type of query you want.

 

[bpaquette]

perfect, thanks!