ComboBox with Multi columns

[DBH]

I have a combo box in my Custom Outlook form that has three columns in the
combo box. This data is retrieved via an Access database
when I look at the Value property of the combo box, I can only see one of
the columns ( I believe its the bound column in the combo box.
How can I access the other values in the selected line of the combo box?
( I need to place the addtional info in other parts of my form, typically a
text box)
Thanks!
Dave H

 

[Sue Mosher [MVP]]

Use the ComboBox.Column method for that. See
http://msdn.microsoft.com/en-us/library/bb207615.aspx

 

[DBH]

Tried cboGroupCategory.Columns(1).Value and a couple variations and Outlook
says its it doesn't support this property or method.
Am I missing something?
Thanks!
Dave

 

[Sue Mosher [MVP]]

Yes, you apparently missed the fact that the method name is Column, not
Columns.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[DBH]

Eyesite.... A wonderful thing to have!!!!
Thanks and it worked great!!!
Regards and many thanks!!!
Dave