Combobox filter using hidden text box and LIKE in SQL not working

[Robyn_P]

Hey,

I'm at my wits end.

I have a method that I use to filter combo boxes and list boxes that works on all of my forms except one, where the filter has no effect and I can't for the life of my work out why. My only thoughts are that this combo box is based off a query and I'm trying to filter on the bound column rather than being based on a table, but I can't see why that should matter.

Here's the position.I have a form.

My form has a combobox called cboMateGroups
It has a filter box, txtFilter. Where people type in text which is meant to filter the list of entries that show up in cboMateGroups
It has a hidden text box called txtHidden.

The OnChange event of txtFilter contains the following code.
me.txtHidden = me.txtFilter.text
me.cboMateGroups.requery

The data in cboMateGroups is as follows it's based on a query, I don't know if that matters.



Column 1: MateGroup, Sort ascending, criteria LIKE "*" & [Forms]![frmReviewMates]![txtHidden] & "*"
Column 2: Status

Column 1 is the bound column

I'm really not sure what else to write. I can type anything into txtFilter and the combo box isn't filtered, no errors, just no filter. I use Exactly (well clearly not exactly) the same method on at least 6 other forms and it works perfectly.

(P.S. I really like this method for filtering long lists/combo boxes)

Any ideas, anything would be really appreciated. It's not crucial but I don't like not understanding and I have no idea. If anything isn't clear just let me know.

[Robyn_P]

Don't worry. I'm a moron. Had some other vba come that was setting the row source. I've found that if you program the row source that takes precidence.

Have removed that code, it's and I know better methods now, and everything is working fine.

Thanks.

PPS. It really is a nice easy filter as you type method. I also change spaces to asterisks in the onkeypress event.

[pbaldy]

Thanks for updating the thread! I'll mark it solved.