Combo Box value search (Any Part of Field)

[Suresh_Murugan]

Hi, I'he a question. How to filter in combo box (any part of field) value type any one match word.
Row Source: Table/Query value.
ex.
123456
234561
1D-51-26-01
1E-51-26-01

But I want any part of field word search show all related values
ex. Type "5"
shows 123456
234561
1D-51-26-01
1E-51-26-01

 

[Ranman256]

The query will have this criteria,

Select * from table where field like "*" & forms!fMyForm!cboBox & "*"

 

[Suresh_Murugan]

The query will have this criteria,

Select * from table where field like "*" & forms!fMyForm!cboBox & "*"

Already tried this. But some data not showing. Thanks for your reply.

 

[Ranman256]

It works,I use it.
Is your combo bound column correct?
Is your form name correct?

Use the Picker, it always spells syntax correctly.