Universal Filter

Universal Filter

The Nifty Universal Filter was created in answer to this question on Access World Forums (AWF):- https://www.access-programmers.co.uk/forums/threads/search-form-by-field-yes-no.317953/#post-1768264 – I call it a universal filter because in the process of testing, I tested it against one of the MS “Northwind Database” Tables the “Products Table”… The products table had a checkbox to denote if a product has been discontinued. With a bit of faffing about I managed to get a combo-box setup which could interrogate this checkbox/Boolean field. By accident, I managed to create two distinct combo boxes, combo boxes with different characteristics. I could take advantage of these differences and the combos could be treated by the VBA code in a different manner. This Discovery allowed me to create the two types of combo box, one for returning a chosen value from in the combo and the other for deciding whether to show the Boolean values as “Yes” “No” or “ALL”…

Universal Filter

Universal Filter

Video 1 (2:30)

Universal Filter from Nifty Access

Two different types of Combo Boxes

  • A Combo that Filters a boolean field:- Yes, No, All
  • A Combo that Filters from a List 

Category Combo – Filters by Category
Soups, Candy, Serial, Grain…

Filter by Availability – (Boolean)

  • All Soups
  • Available Soups
  • Discontinued Soups

Universal Filter

Video 1 (2:30)

Nifty Access YouTube Thumb Nail
Play Video

More - Heading HERE:-

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.