Open Query design grid from a form.

sehmke

Registered User.
Local time
Today, 03:33
Joined
Sep 2, 2004
Messages
19
I have a database with a switchboard form with buttons that lead to other forms but also to some standard queries that I have defined and saved.
From time to time I wish to create a different query (on the fly). I know I could just click the “new query” button on the database window but I have it hidden.
So I want to create a button on my switchboard form which opens the design grid for queries (Query1), including the “Add Tables” dialog box.

Any thoughts?
 
Code:
DoCmd.RunCommand acCmdNewObjectQuery
 

Users who are viewing this thread

Back
Top Bottom