Prev: how can I insert a "$' to print before my price label?
Next: external use of an Access Table
From: blueman on 18 Jun 2008 17:00
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
From: KARL DEWEY on 18 Jun 2008 17:29
In the row source make the SELECT read like this ---
SELECT [Job ID], [Customer Name] & " " & [Job Name] ....
and change Column Count to 2.
--
KARL DEWEY
Build a little - Test a little


"blueman" wrote:

> 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
>
 | 
Pages: 1
Prev: how can I insert a "$' to print before my price label?
Next: external use of an Access Table