Combo box bound column not working

[Gkirkup]

I have a table of countries and country codes, two fields. Then I have a combo box in which the user selects a country, and the country code gets applied to the control.
However, it does not work. I am entering '2' in the Bound Column, but what gets selected and put into the control is always column 1, the country name.
How do I make it load the value in column 2 into the control?

Robert

 

[MarkK]

Can you tell us some other properties of the combo, namely...

• RowSource, and if only a query name, please show the SQL
• ControlSource
• ColumnCount
• ColumnWidths

 

[Gkirkup]

Rowsource: Country codes, a table with three fields, COUNTRY, CODE and APPROVED (a yes/no field)

Control source: O_CNTRY. A text field in a table.

Column count: 3

Column widths: 1";0.5";0.5"

Bound column: 2. But no matter what I enter here, I always get column 1 in the control.

Robert

 

[MarkK]

That row source is not valid SQL. What is the exact SQL?

 

[Gkirkup]

RowSource: Country Codes

That is the table name. Should I change it to a query?

Robert

 

[MarkK]

No, what are the fields in the table, in the order they appear in the table?

The table has two fields? But the combo has three columns?

 

[Gkirkup]

No the table has three fields. I skipped one in my initial description.
This does not appear to work, so I did a work around. I made a query in which the country codes are the first field, and so it works.

Robert

 

[MarkK]

Great. Well done!