Hi

Is it possible to embed the query design mode screen into a form?
I would like to be able to allow users of my solution to edit and
create new queries but I have developed an interface with consistent
headers and side menu etc and it would not be very smart if the only
way they can access this design mode is via a separate screen that
doesn't fit within the current design.
So is it possible to embed the design mode screen into a form so that
when they choose an query to edit it opens up in this window?

Thank
Katie

On Nov 24, 4:33*am, KatieK <katie.k... (AT) aether-uk (DOT) com> wrote:

I do what you want by putting combo boxes on a form and letting the
user pick from values in the combo box. Then in the query that drives
the reports, in the fields that the user picks, I put an expression
forms!nameoftheform!nameofthecombobox in the criteria line. You
could also put an unbound field on that form for the user to enter a
date. I stick with combo boxes and date boxes for these applications
so the user has to enter a valid criteria. Best of luck -- Nance

KatieK wrote:
I don't think so. You can try
docmd.OpenQuery "YourQueryName",acViewDesign
if you'd like.

Might be worth a try, perhaps you can embed MS Query into a form
instead? I have not tried this, but in theory it should be
controllable. Not sure if the resultant queries are compatable or not,
but still.....

The Frog