ComboBox with Multi columns
 

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

ComboBox with Multi columns
 

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

--
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" wrote in message
...
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

ComboBox with Multi columns
 

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]" wrote in message
...
Use the ComboBox.Column method for that. See
http://msdn.microsoft.com/en-us/library/bb207615.aspx

--
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" wrote in message
...
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

ComboBox with Multi columns
 

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" wrote in message
...
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]" wrote in message
...
Use the ComboBox.Column method for that. See
http://msdn.microsoft.com/en-us/library/bb207615.aspx


"DBH" wrote in message
...
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)

ComboBox with Multi columns
 

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

"Sue Mosher [MVP]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
Use the ComboBox.Column method for that. See
http://msdn.microsoft.com/en-us/library/bb207615.aspx


"DBH" wrote in message
...
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)