Create combo box to search on any part of field 2

[Terpsfan]

The default behavior of Access is to search through a combo box based on the start of the field. Is there a way to search through a combo based on any part of the field. I've never seen this implemented but I am sure there is a way to get it done. Thanks

 

[ormsk]

There is a way.


In the On Change event of the combo box...

Dim SQL As String

SQL = "SELECT MyField FROM Table1 WHERE MyField Like '*" & Combo1.Text & "*'"

Combo1.RowSource = SQL
SendKeys "%{DOWN}"

The code below...

SendKeys "%{DOWN}"

just opens the combobox up so u can see the effect on each keypress

 

[Terpsfan]

Ormsk,

Thanks for your solution. It works very well.

 

[aron7awol]

It looks like it's working in that the combobox does search based on what's in the box, but when you try to make a selection it doesn't work. Any ideas?