Form - filter combo box value

[kitcheong]

I need help:

There are 3 column in a combo box, ID is bound column

Part no ID Description
0040 1 class 40-1
0040 2 class 40-2
0040 3 class 40-3
0041 4 class 41-1
0042 5
0042 6

When key in part no 0040, 3 rows under 0040 will be listed out only, filter and match as value entered only. do not show others part no in the combo box selection.

Please help me as I really can't resolve it.


Thanks in advance.

Kit

 

[pr2-eugin]

Where are you typing in 0040? Is it in a TextBox, and you want to filter the combobox based on that?