Hi Stephen
Just exchange the colunm one for two.. And set the mycombo.boundcolumn to 2
HTH
Claudio
>
>I seem to have gone brain dead or I can't get a combobox to work the way I want it to:
>
>Two columns (easy) from fields - column one the country abbreviation, column two the full country name. store the abbreviation to a table. So far, no problem. Now the users decide they don't want to search on the abbreviation (incremental search) but want it to work on the full name (column 2).
>
>Only way I can get search to work is make column 1 the full name and bind to column 2 but this causes the fullname to be displayed and that is not desired (not enough room on form and not needed - once selected). How can I force the incremental search to use column two, not one?
>
>Thanks for advice
>
>Steve
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20