column not showing in combo box

[plantfinder]

I have a combo box with the following 3 fields:

Job ID, Customer Name, Job Name

The Column Count is 3
The widths are set to: 0";1.5";1"
The list width is set to: 2.5"
The Width is set to 3.2813"


The first column correctly does not show and the value is stored where I want it.

When viewing the list in drop down mode, both the second and third columns are visible, which is what I want.

However, after selecting a row, only the second column (Customer Name) is visible in the combo box on the form. I want both the second and third columns (Job name) to be visible. Can anyone help?

Thanks

 

[Remou]

You would need to combine the columns in the row source and have two columns rather that three, for example:

RowSource: Select [Job ID], [Customer Name] & ", " & [Job Name] From tblT

 

[TheAceMan1]

How are ya plantfinder . . .

[blue]. . . I want both the second and third columns (Job name) to be visible.[/blue]

Why? . . . we could help you more if we knew!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[ProgramError]

Suggest you keep them separate. Create a separate textbox and put the job name in that. Why combine them?

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Remou]

ProgramError
Why not combine them? It is merely a display, the key column should be the bound column.

 

[TheAceMan1]

[blue]Why not combine them? It is merely a display . . .[/blue]

What if it happens to be a [blue]bound[/blue] combobox?

Bound/Unbound hasn't been verified yet . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Remou]

It has not been stated that the bound column is Job ID, but it is implied by the OP:

Job ID, Customer Name, Job Name

The Column Count is 3
The widths are set to: 0";1.5";1"

It would not be good practice in the above set up to have anything but Job ID as the bound column, so if either Customer Name or Job Name is bound, I would urge that this be changed.

 

[plantfinder]

You are correct. Job Id is the bound column. It works fine combining the columns. Thanks