Combo box bound column

[Guest]

Does the combo box only capture data in the first column when you use a multi
column display? I want to display the list as p_type, type_phase and capture
type_phase. Tried changing the bound column value but doesn't help and it
always show the 1st column value.

I had to reverse the field order in the select statment to make it work.

Help please,
Thanks

 

[kingston via AccessMonster.com]

Without modification, the combo box will save only the value from one of the
columns to the control table. Changing the bound column will change the
column from which this value is extracted. It will display multiple columns,
and you'll be able to use the other values as long as the control is
available. However, it will only record one value unless you add a custom
procedure.

 

[fredg]

Does the combo box only capture data in the first column when you use a multi
column display? I want to display the list as p_type, type_phase and capture
type_phase. Tried changing the bound column value but doesn't help and it
always show the 1st column value.

I had to reverse the field order in the select statment to make it work.

Help please,
Thanks

After you have made your combo box selection, the combo box will only
display the first column that has a width greater than 0", not
necessarily the bound column.

Add some unbound text control's to your form.
Set their control sources to
= ComboName.Column(1)
= ComboName.Column(2)
etc.

Note... Combo Boxes are zero based, so Column(0) is the 1st column,
Column(1) is the 2nd column.

 

[Guest]

Thanks for the help. May just split them out.

After you have made your combo box selection, the combo box will only
display the first column that has a width greater than 0", not
necessarily the bound column.

Add some unbound text control's to your form.
Set their control sources to
= ComboName.Column(1)
= ComboName.Column(2)
etc.

Note... Combo Boxes are zero based, so Column(0) is the 1st column,
Column(1) is the 2nd column.