Originally Posted by
drexasaurus
I think someone must have asked this question before, but my searching skills must be sub-par.
I have a combo box that is bound to a integer field (SQL Server linked table, if that's significant), but displays the text description of that key by hiding the number. The problem is, when users want to filter or search for items in the form using that combo box, they are asked to enter a number, and searches for the code don't work, because Access is trying to compare them to the numbered key.
Is there a way to have the user to be able to search and filter on this combo-box using the built-in access GUI?
Thanks.