>thnx Borislav for you reply. When i use your solution i lose the information of my seconde column but i want to keep the information in the second column and not display it. The reason is that i use the info of the second column further in my program.
>
>thnx
Oops,
Change:
thisform.Combo1.ColumnCount = 1
to
thisform.Combo1.ColumnCount = 0
Then second column will not be visible but you could use it as a Value of the combo.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.