The Most Powerful form Filter and Requires almost No Code

[MajP]

May want to read my addendum which explains how the images work using the gallery.

The Most Powerful form Filter and Requires almost No Code

NOTE: See updated code below. I recommend using the updated class module that @arnelgp modified. It further simplifies building a search form and addresses some bugs...

www.access-programmers.co.uk

 

[Lightwave]

Very cool - my only thing I might suggest (which might not be practical) dynamically adjust the width of the drop down window to the width of the widest selectable item...

One thing I used to do in my MS Access applications in tabulated forms was to have the labels activated and set to sort alphabetically ascending on left click and descending on a right click.. and normally I would make sort on multiple columns... depending on my own preference and with respect to my opinion on a sensible sort on the column. Not quite a filter but worked well for many of my applications.

Here's a link to my notes on it from ten years ago.
Sorting on Mouse Left and Right Click