ComboBox with Multi columns

  • Thread starter Thread starter DBH
  • Start date Start date
Status
Not open for further replies.
D

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
 
Use the ComboBox.Column method for that. See

http://msdn.microsoft.com/en-us/library/bb207615.aspx

Sue Mosher

"DBH" <dbh@siscom.net> wrote in message

news:%23rlK7YWMKHA.4124@TK2MSFTNGP04.phx.gbl...
> 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]" <suemvp@turtleflock.com> wrote in message

news:%23Umk$fWMKHA.1372@TK2MSFTNGP02.phx.gbl...
> Use the ComboBox.Column method for that. See
> http://msdn.microsoft.com/en-us/library/bb207615.aspx

> > Sue Mosher
> > >

> "DBH" <dbh@siscom.net> wrote in message
> news:%23rlK7YWMKHA.4124@TK2MSFTNGP04.phx.gbl...
> >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

"DBH" <dbh@siscom.net> wrote in message

news:eXfMBuWMKHA.5460@TK2MSFTNGP02.phx.gbl...
> 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]" <suemvp@turtleflock.com> wrote in message
> news:%23Umk$fWMKHA.1372@TK2MSFTNGP02.phx.gbl...
> > Use the ComboBox.Column method for that. See
> > http://msdn.microsoft.com/en-us/library/bb207615.aspx



>

>> "DBH" <dbh@siscom.net> wrote in message
> > news:%23rlK7YWMKHA.4124@TK2MSFTNGP04.phx.gbl...
> >>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]" <suemvp@turtleflock.com> wrote in message

news:ehBbiFXMKHA.4572@TK2MSFTNGP02.phx.gbl...
> Yes, you apparently missed the fact that the method name is Column, not
> Columns.

> > Sue Mosher
> > >

> "DBH" <dbh@siscom.net> wrote in message
> news:eXfMBuWMKHA.5460@TK2MSFTNGP02.phx.gbl...
> > 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]" <suemvp@turtleflock.com> wrote in message
> > news:%23Umk$fWMKHA.1372@TK2MSFTNGP02.phx.gbl...
> >> Use the ComboBox.Column method for that. See
> >> http://msdn.microsoft.com/en-us/library/bb207615.aspx

>
> >
>>> "DBH" <dbh@siscom.net> wrote in message
> >> news:%23rlK7YWMKHA.4124@TK2MSFTNGP04.phx.gbl...
> >>>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)


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K Incorporate selection from combobox into body of email Outlook VBA and Custom Forms 0
T Outlook Template - textbox visible based on combobox selection Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
C Autofill subject line in appointment from options selected in combobox Using Outlook 6
B Contact Page 2 Combobox via Registry Outlook VBA and Custom Forms 6
N Combobox in outlook add ons toolbar not firing event on main window resized Using Outlook 3
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
J userform combobox Outlook VBA and Custom Forms 1
R combobox list in userform Outlook VBA and Custom Forms 1
K Alignment in Combobox Outlook VBA and Custom Forms 1
P Setting combobox properties from Outlook 2007 Add-in Outlook VBA and Custom Forms 9
K Adding watermark to Combobox in Outlook. Outlook VBA and Custom Forms 1
C ComboBox data Outlook VBA and Custom Forms 2
S ComboBox (using Commas) Outlook VBA and Custom Forms 4
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
S Default Selection For Multi-Select List Box Outlook VBA and Custom Forms 1
O VBA Cases with Listbox - Can you use Multi-Select? Outlook VBA and Custom Forms 4
A Multi-select Listbox Outlook VBA and Custom Forms 6
L Unintentionally closing Outlook w multi monitors Using Outlook 3
J Help Needed With Multi-Step Login Email Address Using Outlook.com accounts in Outlook 1
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
Mark Foley Outlook multi-spacing Thunderbird signatures when replying Using Outlook 0
O How to display multi-line task in To-Do List - Outlook 2010 Using Outlook 1
K Outlook 2013 Multi Accounts set Default different calendar Sender Using Outlook 2
B Multi Room (10) Calandar Using Outlook 1
S Outlook 2010/Exchange 2010 Multi Mailboxes (Server unavailable) Using Outlook 6
S Outlook 2010 and Multi-Part MIME Messages Using Outlook 2
M Multi year view printing problem Using Outlook 0
R Can BCM use Public Folders and Exchange for multi-user/ BCM (Business Contact Manager) 1
A Daily hours of recurring/ multi-day appts, & accessing mult calend Outlook VBA and Custom Forms 2
mll persistently customise columns in outlook advanced search Using Outlook 3
C Configuring Inbox columns Using Outlook 2
E Custom formula for columns Using Outlook 3
O Set columns for all (sub)folders Using Outlook 8
C Columns in relationship list BCM (Business Contact Manager) 1
W Outlook Columns "First Name" & "Last Name" Using Outlook 2
C Outlook 2007 Select Names Default columns Using Outlook 3
R How to modify Outlook Select Rooms form columns Using Outlook 1
C Outlook 2007 - Recover Deleted Items - Columns to Choose from Using Outlook 1
S Change Columns of Linked Accounts and Business Contacts BCM (Business Contact Manager) 1
C Change the related contect diplay columns BCM (Business Contact Manager) 4
williamlambton Customised To, CC, BCC and Have-replies-sent-to columns in message lists. Using Outlook 16
T User Defined Fields_Difference between columns BCM (Business Contact Manager) 4

Similar threads

Back
Top