Lookup multiple columns in combo box

[fcp]

Is there a way to lookup information ina bound combo box based on either columns.



Here is a scenario I have a bound combobox with two columns Column(0), and Column(1) both visible. I want to search the combobox based on either value of both columns. In the words if I search ID it will lookup the value and if I search by name it will also lookup names.

Is there a sample VB script in the after update event of combo box that will accomplish that?


Much appreciated!

[June7]

If you have a unique ID value, why also need to search by name? Are users allowed to enter a name not in the RowSource list?