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: