Monday, June 29, 2015

Combobox with Filtering Capability

Here is a combobox that can filter the items in the dropdown list based on what has been typed so far.  It is a good candidate for replacing my xBox class if you don't need a Quickfill/Auto-Complete or if you wanted only a dropdown that is being filtered.  This uses SQL SELECT as RowSourceType.

Before running the sample, there are two things you should know outright:
  • Double-clicking on the textbox portion will clear DisplayValue and will restore the original SQL SELECT
  • I used Ctrl+Enter to trigger the dropdown section
Here are the codes: