INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

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

(OP)
Continuation of this thread: thread702-1756368: Auto-complete combo box...continuation of thread "Combobox as Find As You Type?"

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.

CODE --> VBA

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 

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close