Form filter woes...

[generallyconfused]

Hello all,

I have a form with a combo box. The combo box looks up two values (ID, Item) from another table. The first column width is set to zero so the user cannot see the ID of the item they are selecting.

When attempting to filter (right click combo box, select filter for:, enter item) I receive a data type mismatch error. I realize why I am getting the error, it is taking my text input and attempting to compare it with IDs, which are of course integers.

So my question to you all, is there a way to filter a combo box based on column data other than column 1 of the combobox? Preferably with built in access features. I realize I could build a filter button but that would require me to build a filter button. (Something I don't want to do, my forms are already too cluttered.)

Any help would be appreciated.

Thanks,
GC

 

[generallyconfused]

After a bit of digging I've enlightened myself on the "bound column".

So my question could be stated as, "Can I filter a combo box using an un-bound column?"