Column Not showing after pick in combo box

[blueman]

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

 

[KARL DEWEY]

In the row source make the SELECT read like this ---
SELECT [Job ID], [Customer Name] & " " & [Job Name] ....
and change Column Count to 2.