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.


Form Combo Filter In String (FAQ Help)

Form Combo Filter In String (FAQ Help)

I'm following through this thread:
and I'm confused. It says the combo should have 3 columns, but only explains what 2 of them are. Anyone able to determine what I'm missing?

This is the section of the code, about that part:


'  Column Count 3
'  Keyed on column 1 (record primary key)
'  Showing column 2 (user-readable data) column 2 width > 0
'  First and Second column width=0 

I just want the combo to limit what is in the combo, to what the person is typing, as an InStr search of the 2nd (1st in 0 index) column of the combo.

The combo is used to set the form to filter to the 1 record a user chooses from the combo. There are so many records, the users need to be able to see the list cull down as they type, and they might know part of what they are looking for, but that part may be in the middle, not the beginning of the string.

Thanks for any help!


It is never too late to become what you could have been ~ George Eliot

RE: Form Combo Filter In String (FAQ Help)

nevermind. I kept going over this, and could not get passed how complicated the solutions were. I finally came to terms that I should just handle this differently. Now I'm doing a button with a pop-up form. The form has a text box and a listbox. The listbox has all records (unfiltered) to start.

On change of the text box, the listbox rowsource is reset to it's rowsource, but with a where lcase(xcolumn) like lcase(textbox)

Testing now. I'll find all the ways this doesn't work, refine and then replicate to other combo needs.


It is never too late to become what you could have been ~ George Eliot

RE: Form Combo Filter In String (FAQ Help)

FAQ702-6304: Find As Your Type Combobox
Not sure if you looked at this thread. It turns any combobox to Find as you type, with one line of code.

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!


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