Creating a Form-Based Parameter Query - Dynamic Queries

In this tutorial we will make a Form based Query where they information is taken from an object on the form to be used as Criteria in our Query. this is sometimes known as a Dynamic Query where the user determines the criteria.

[thaliaaleman]

This is exactly what I was looking for, great instructions and easy to follow along. Thank you.

[eccomaggio]

As others have said: this is exactly what I was looking for, and really clearly explained. Many thanks!

[davegoodo]

Great to hear an Aussie voice in a very useful video.

[malarky]

Thank you man. This wasnt an exact solution to my exact problem, but it allowed me to make a decent work around for now until I can go back and work on it. I am trying to learn access on my own and I figured Access 2016 would have a macro for a button that just let a user generate their own reports, but I was wrong.
But as I said, until I get that figured out, I think this will be a decent work around for a beginner.

[drskbcard]

This is exactly what I was looking for to make Access do what I needed. Thanks a lot !!

[Jojosmith]

Excellent. Thanks a lot for your valuable lesson. Subscribed & definately liked! Looking forward to more tutorials 👍

[Dubya]

This solved hours of work. Thank you so much!

[shafiqurrehman]

thank u sir, you gave me a solid start for dynamic queries. thank u so much.

[denisefornara-ivarson]

Absolutely brilliant!!! Exactly what I needed and so easy to follow - thank you so much! Would there be a way to make the button show the results in Report form for printing? Perfect 7 minute tutorial!

[yeamusic]

Amazing! Well done and thank you for making this video! Saved me hours! :-D

[ndiagandiaye]

Thanks. Precise, small but complete. Really did help me.

[charlottegardner]

Great tutorial. Thank you. I have a question, when you close the query and return back to the form, the combo box still displays the previous selection. Is it possible to make this box clear ready for another selection?

[digitalmasters]

Thank You Very Much Sir, May you live long "Ameen"

[Ednut]

Clearly explained Thank you. Is there a different critera structure for Crosstab queries? I've tried this approach only to get error messages indicated 'MS Access database engine does not recognize the criteria as a valid field name or expression'. Same criteria works on select queries without any problem!

[Sathishsgn]

Hi Leon, Can you please explain the same for list box with Multi-select property enabled. I created a form with a list box for filtering value from a table and when I filter the results using parameter criteria in another query it does not work. When I disable multi-select property it is working but When I enable multi-select it does not filter and just displaying all the results. I just want to know what is criteria to filter using multi-select list box.

[katiispiess]

Hi Leon,

I've been trying to do the query the way you showed it. However, I think my table is set up wrong. I have the subject headings in the columns (art, math, Social Studies, etc.) with a yes/no data entry. Could you show me an example of the table you used for the combo box and query? Thank you.

[navaskdl]

HI I Need a help
I am able to create conditions(15 steps of process and their delay status - Done, Balance, Delay) and display in the form. But I cant apply this same conditions in query. It says too complex.

[tsywanicz]

This works great when I run my form itself. But when I run the form through a navigation form it does not work? Can you explain why this is and what would resolve this?

[doko]

It is only applied on the primary Key and It might be because the values in the combo box bound to that key. I tried to use the parameter criteria on other fields (non-key fields) and it failed to work.

[ManojSingh-womq]

Can we add integrate "from date" to "to date " in this form? Please guide.