Problem with duplicate (1 Viewer)

[lana]

Hi everybody,

I am new on this so bear with me.

I have a table which has two fields one is person's name and the other is a code.

name code
smith 1001
John 1001

Now when I use a combo box to show the "name" field but the bound column is set to the "code" then the selected name is not shown in the combo box. It shows the first name which has the same code.

Can any one help me on this?
Many thanks.

 

[wiklendt]

adjust your column widths property. if you have 3 columns in your record source, you should specify the width of each, even those you do not want to see.

that is, for three columns, where the second column is the code that you don't want to see, put something like 2cm;0cm;3cm

(where do you get first name from? you don't mention it in your setup, but you say you see it in your combobox?)