How do I get a dropdown to display more then 1 column?

[bigfoot]

I need a multi column dropdown. Is there a way to do this, or do I have to use a custom control. A listbox will not do. I want the user to search for a name and then I get the id form the name. I need the id to do a findfirst.

Thanks
Gary The door to life is never locked, but few have the knowledge to open it.

 

[culshaja]

I would concatenate the columns into a single column in a query and then bind, or add that data to the combobox.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[bigfoot]

Thank you, but I need to extract the information also.

I found the solition: Microsoft Forms 2.0 library
There is a multi colum dropbox in there.

Thank You to dpaulson for his solution.

The door to life is never locked, but few have the knowledge to open it.

 

[Ruairi]

you could easily do this with a standard combobox, if the user does not need to see the ID.
<code>
Combo1.AddItem &quot;Name #1&quot;
Combo1.ItemData(Combo1.NewIndex) = 1
</code>

The User Will see &quot;Name #1&quot; (without quotes) in the combo box but in the click event you can get the ID.

<code>
Dim SelectedID As Long

SelectedID = Combo1.ItemData(Combo1.Listindex)
</code>
Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com

 

[bigfoot]

Thank you, I looked at that. I needed more then 2 columns and they had to be text.

I found the solition: Microsoft Forms 2.0 library
There is a multi colum dropbox in there.

Thank You all for your help.

Gary The door to life is never locked, but few have the knowledge to open it.