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

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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
>

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]" <(E-Mail Removed)> wrote in message
news:%23Umk$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>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
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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]" <(E-Mail Removed)> wrote in message
> news:%23Umk$(E-Mail Removed)...
>> Use the ComboBox.Column method for that. See
>> http://msdn.microsoft.com/en-us/library/bb207615.aspx

>>
>> "DBH" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>>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)

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

"Sue Mosher [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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]" <(E-Mail Removed)> wrote in message
>> news:%23Umk$(E-Mail Removed)...
>>> Use the ComboBox.Column method for that. See
>>> http://msdn.microsoft.com/en-us/library/bb207615.aspx
>
>>>
>>> "DBH" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>>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)
>
>