Selecting the right column to input

[t3nchi]

I have a combo box which I pull values from a table which has 2 columns. When I pull down the menu, both columns show but I want the 2nd column to fill out the field. Not the 1st column (which it is doing by default)

How do I fix this? Thanks.

 

[pbaldy]

In the properties of the combo you will find one for Bound Column

 

[Pat Hartman]

When the combo is "closed", it shows the contents of the first visible column. So, in order to make the second column show, you have two choices, swap the first and second columns or hide the first column so the second one is the first visible one.

 

[t3nchi]

When the combo is "closed", it shows the contents of the first visible column. So, in order to make the second column show, you have two choices, swap the first and second columns or hide the first column so the second one is the first visible one.

Swapping= you mean swapping the order in the original table itself?

and the 2nd option, how do u do that?

 

[neileg]

Swapping= you mean swapping the order in the original table itself?

Your combo should be based on a query, not a table. Change the order in the query.

and the 2nd option, how do u do that?

Go into the property sheet for the combo and reduce the column width to zero for the first column.

 

[DAW]

Sorry to labour this one, chaps, but I'm struggling with this one also!
My combo is based on a query. I need the first column to be surnames so that the user can quickly navigate (i.e. pressing J jumps to the surnames beginning with J), but I want the table to store the employee ID no that is also in the combo. It seems that no matter what I set the boundcolumn property to, or what size the columns, the table stores the surname.

 

[DAW]

Oh, Hang on...
If I set the 1st column (employee ID no.) width to 0 on the form then I can use my quick navigate. Then set the 1st column width in the table to 1 then it stores the employee ID. Is this the correct way of doing this??

 

[neileg]

Yes, it is.