• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Create dynamic query form?

Is there a way in Access to create a dynamic query form something like the attachment I've embedded?

Form example
3 Solutions
Certainly possible, but why do you want to do it? I ask because if you have an appropriate BOUND form you could use 'Filter by form' more quickly.

There are other threads and articles on EE that describe how to build dynamic criteria forms
e.g. Using a Criteria Form to Filter Records
It's certainly possible.
Of course, the very best example of how to do it is Access's own Query Editor.
It's a superlative piece of UI.
What operational need would require going to the immense effort of recreating it?
Jeffrey CoachmanMIS LiasonCommented:
This question comes up quite a lot.

While it sounds like a great idea, ...after deeper consideration you will quickly realize that it will be more complicated than you expected.
Not Equals
Contains/ (Like)
Does not contain
Begins with
Ends with
Text searches
Numeric searches
Multi table Join queries

The Idea here is to create a "Natural Language" query builder for your users, ...correct?
The "simpler" you make it for your users, ...the more difficult this becomes for you to design.
Many "Natural Language" query builders have been created in the past, ...but none really ever caught on in the mainstream.
See here (http://en.wikipedia.org/wiki/Natural_language_user_interface)
...Specifically under the section called "Challenges".

You can certainly create something very "simple", ...but users will always want/need more.

These types of systems are typically based on "Filtering", ...not really based on building a complete query.
See Here (Parts 4 5 and 6)

In the end, you will realize that it is far easier to just educate your users on how to use the query builder.
Either that or create something "simple", ...then for any users who need more, ...you can teach them the query builder. (Where almost anything is possible)

Ultimately, ...for me at least, Learning SQL might be the solution...
SQL is more or less universal, ..so at the higher end, ...some things are just not possible in the Access QBE (Query By Example) grid, ...and can only be done with SQL.

Helen FeddemaCommented:
Not sure exactly what you need, but my Fancy Filters sample database might be helpful; it allows users to select values of various data types from combo boxes, and creates a filtered query, displaying the results in a subform.  Here is the link for downloading it:


and here is a screen shot of the form:
Fancy Filters form
SteveL13Author Commented:
Thanks for the advise.  I'm going to use the built in Query Designer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now