Choosing values from Combo Boxes with multiple columns

[tehNellie]

OK my brain has died. I know this should be child's play or something obvious to search for but I'm drawing a blank.

I have a combo box bound to a table with two columns, an ID and a companyname.

When I ask for me.cmbcombobox.value I get the ID, what I really want is the company name information.

Whats the syntax, pretty please

 

[missinglinq]

Indexing of Comboboxes is Zero based, so the idea field would be
Me.cmbcombobox.Column(0) and the company name would be Me.cmbcombobox.Column(1) so

YourCompanyName = Me.cmbcombobox.Column(1)

should retrieve your data.

 

[RuralGuy]

me.cmbcombobox.Column(1)

 

[missinglinq]

And it's a tie, Ladies and Gentlemen!

 

[tehNellie]

*slaps head*

Thanks guys, exactly what I needed

 

[RuralGuy]

Something tells me, based on the order the posts appear in the thread, that you were actually first Linq. It is snowing here now and my fingers were not moving as fast as usual.

 

[missinglinq]

I thought all you mountain men were used to snow!

 

[RuralGuy]

Not the first one of the season!!