Sample database demonstrating Find-as-you-type VBA class for combo box. 1

[BenSacheri]

Continuation of this thread: thread702-1756368

The images shows what happens when you type "del" into the combo box. It is configured to search any part of the word in two columns.

Only two lines of code need to be added to your form after the Class Module has been added to the project.

Private faytFindCompanyOrContact As New clsFindAsYouTypeCombo ' You must declare a class variable for each combo box.

Private Sub Form_Open(Cancel As Integer)

    ' Initialize the fayt combo box and link it to an existing combo box that already has a row source.
    faytFindCompanyOrContact.InitalizeFilterCombo cboFindCompanyOrContact, "CompanyName;ContactName", False, True

End Sub

 

[kjv1611]

I wonder if the same could be done across three combo boxes. Definitely food for thought. Yes, I actually do have a use case for that, but it might be more complex than 2 straight forward lists. Hopefully I can find the time to take a look at your example in the near future.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57