Combo box question

[YNWA]

Hi,

I have a combo box that works.

It has 3 fields (id, code, name). When I click the combo I see the 2 fields I want (code, name).

But once I make the selection, the combo box just shows the code field.

So instead of seeings A - Home as I do when i click the drop down, I just shows A in the form field.

Any ideas?

Cheers
Will

 

[JamesMcS]

I think the combo box shows the contents of the bound column. I've got around this before by having a text box next to the combo box, whose control source is set to the combo's relevant column number.

 

[YNWA]

The bound column is 1, which in the table is field ID.

The combo shows columns 2 and 3, but when I select an option, it only shows column 2 on the form.

 

[YNWA]

I'm pretty sure bound column field starts at 1.

1 = 1st field in table
2 = 2nd field

In VBA your 1st column start at 0.

??