Selection from drop down list does not show in text box part of combo box

[Tony Girgenti]

Hello.

When i select an item from a dropdown list in a combo box, it doesn't put
the item in the text box part of the combo box. It just leaves it blank.

The first three fields in the table are PENDING ORDERSID, COMPANY NAME and
SIDEMARK. The field i am using for the combobox is SIDEMARK. Here are my
properties:

Row Source Type = Table/Query
Row Source = SELECT DISTINCT [PENDING ORDERS].SIDEMARK FROM
[PENDING ORDERS] WHERE (([COMPANY NAME]=Forms![CHF - WIP]!Combo0));
Column Count = 1
Column Widths = 2"
Bound Column = 2
List Width = 1"

Any help would be greatly appreciated.

Thanks,
Tony

 

[Rick Brandt]

Hello.

When i select an item from a dropdown list in a combo box, it doesn't
put the item in the text box part of the combo box. It just leaves
it blank.
The first three fields in the table are PENDING ORDERSID, COMPANY
NAME and SIDEMARK. The field i am using for the combobox is
SIDEMARK. Here are my properties:

Row Source Type = Table/Query
Row Source = SELECT DISTINCT [PENDING ORDERS].SIDEMARK
FROM [PENDING ORDERS] WHERE (([COMPANY NAME]=Forms![CHF -
WIP]!Combo0)); Column Count = 1
Column Widths = 2"
Bound Column = 2
List Width = 1"

Any help would be greatly appreciated.

Your ComboBox has only one column but you have the BoundColumn property set to
2. Change that to 1.

 

[Tony Girgenti]

Thanks Rick. That fixed it.

I wish i understood how to use the combination of Row Source, Column Widths
and Bound Column. I thought i did after reading the help on those fields.
Apparently, it is not what i thought it was.

This is not the first time i have been stumped by not using those properties
correctly.

Thanks again.
Tony

Hello.

When i select an item from a dropdown list in a combo box, it doesn't
put the item in the text box part of the combo box. It just leaves
it blank.
The first three fields in the table are PENDING ORDERSID, COMPANY
NAME and SIDEMARK. The field i am using for the combobox is
SIDEMARK. Here are my properties:

Row Source Type = Table/Query
Row Source = SELECT DISTINCT [PENDING ORDERS].SIDEMARK
FROM [PENDING ORDERS] WHERE (([COMPANY NAME]=Forms![CHF -
WIP]!Combo0)); Column Count = 1
Column Widths = 2"
Bound Column = 2
List Width = 1"

Any help would be greatly appreciated.

Your ComboBox has only one column but you have the BoundColumn property
set to 2. Change that to 1.