No critieria in query search when drop down box is empty

[Stevestan1]

I have a query that is connected to a form. There are 2 dropdown boxes in the form that are connected to two columns on the query. I would like the query to search for all records if those 2 dropdown boxes are left empty, but currently if either one is left empty, no records are returned. Anyway to get the blank dropdown boxes to convey "search with no criteria"?

[jimatqsi]

This thread may be helpful.

http://bytes.com/topic/access/answers/897756-query-based-combo-box-needs-return-all-values-if-null

Also, look in the articles, there is a very good article by NeoPa about filtering on a form.

Jim

[Stevestan1]

Where are the articles located? I don't see a section for them on the site

[NeoPa]

Near the top of this page you will see :
bytes > microsoft access / vba > microsoft access / vba questions
This is generally referred to as the Bread-Crumbs, and refers to the Hantsel & Gretel fairy-tale. This enables you to link back to parent forums of the one you're in. The articles forums (or Insights as they are generally called) can be found if you go up one level to bytes > microsoft access / vba. In there you will find a large number of Article/Insight threads.

Specific article referred to may be included in :
Cascaded Form Filtering
Example Filtering on a Form

Have fun!

[Robert Wilson]

thanks for the post