Combo box with 2 columns filled by value list (1 Viewer)

darbid

Registered User.
Local time
Today, 11:25
Joined
Jun 26, 2008
Messages
1,428
I am trying to create a combobox with two columns (the second hidden) from a ValueList with the second column being the bound column.

My problem is that I cannot get the combo list to return the second column.

ColumnCount = 2
ColumnWidths = 2cm;0
RowSource Type = Value List
Bound Column = 2
Row Source = John Smith; "john.smith@hotmail.com";Jim Hill;"jim.hill@hotmail.com";Jack High;"jack.high@hotmail.com"

as far as I thought ME.mycbobox.value should return the email address being the second column
 

wazz

Super Moderator
Local time
Today, 18:25
Joined
Jun 29, 2004
Messages
1,711
ME.mycbobox (value is not required) always returns the first column. you'll have to specify a specific column.

ME.mycbobox.column(1) <-- 2nd column
 

Users who are viewing this thread

Top Bottom