If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: how to display two column value in combobox DisplayMember

That's because it's not possible. If you want to display multiple columns then you have to derive your own class and add that functionality. There are various examples on the web. Search for multicolumn combobox or the like and you'll find them.

Re: how to display two column value in combobox DisplayMember

@dee-u, Thatís too cool man thanks that will help a lot on other projects as well. @crisjala, some times the best way to learn is not to be given the answer but close that will help you not only find the answer but strengthen you over all knowledge. but if you must here is my code based on the cluse dee-u sugested and it works perfect.

Re: how to display two column value in combobox DisplayMember

Originally Posted by weax1569

@dee-u, Thatís too cool man thanks that will help a lot on other projects as well. @crisjala, some times the best way to learn is not to be given the answer but close that will help you not only find the answer but strengthen you over all knowledge. but if you must here is my code based on the cluse dee-u sugested and it works perfect.

Code:

SELECT first_name1 + ' ' last_name2 AS full_name FROM table

Code:

me.combobox1.displaymember = full_name

works like a charme
thank dee-u

I've been hunting for a solution to accomplish this as well. Thanks guys!