Form Combo Filter In String (FAQ Help)

[misscrf]

I'm following through this thread:

http://www.tek-tips.com/faqs.cfm?fid=6295

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!

misscrf

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

 

[misscrf]

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.

misscrf

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

 

[MajP]

faq702-6304
Not sure if you looked at this thread. It turns any combobox to Find as you type, with one line of code.