Combo Box. Change row order?

[Frank Martin]

I have a Combo box selecting products in a
customer price-list.

The columns displayed in this combo box are:

'ProdID', 'Unit', 'Description',
with ProdID as the bound column.

But I want the Combo to display in the order:

'Description', 'Unit', 'ProdID'.

(With the ProdID as the bound column as
before.)

I need to use the 'Description' as an
autolookup.

For some reason I cannot make the Combo
display the columns in this second
arrangement.
I have tried rearranging the columns in the
underlying query which is:

***
SELECT Products.ProdID, Products.Unit,
IIf(Val([Unit])=0,1,Val([Unit])) AS Expr1,
Products.Description, Products.ProductGroup

FROM Products

WHERE (((Products.ProductGroup)<>"S" And
(Products.ProductGroup)<>"B" And
(Products.ProductGroup)<>"EQ"))

ORDER BY Products.Description;
***

The Combo is in a subform linked via
customer.

Please help, Frank

 

[Jeanette Cunningham]

Frank,
Row source query is:

SELECT Products.Description, Products.Unit, Products.ProdID,
IIf(Val([Unit])=0,1,Val([Unit])) AS Expr1,
Products.ProductGroup

FROM Products

WHERE (((Products.ProductGroup)<>"S" And
(Products.ProductGroup)<>"B" And
(Products.ProductGroup)<>"EQ"))

ORDER BY Products.Description;

Combo setup:
Give the combo 3 columns and make column(2) the bound column
Combo numbering starts at 0 for the first column
Set the column widths to something like 6cm;0cm;0cm
(change cm to inches if in US)

Jeanette Cunningham

 

[Frank Martin]

Thanks, but in this case all I had to do was
change the column widths to 0,0,0,6 which
left only the 'Description' column, and left
all the others hidden.
Regards, Frank



"Jeanette Cunningham"
message

Frank,
Row source query is:

SELECT Products.Description, Products.Unit,
Products.ProdID,
IIf(Val([Unit])=0,1,Val([Unit])) AS Expr1,
Products.ProductGroup

FROM Products

WHERE (((Products.ProductGroup)<>"S" And
(Products.ProductGroup)<>"B" And
(Products.ProductGroup)<>"EQ"))

ORDER BY Products.Description;

Combo setup:
Give the combo 3 columns and make column(2)
the bound column
Combo numbering starts at 0 for the first
column
Set the column widths to something like
6cm;0cm;0cm
(change cm to inches if in US)

Jeanette Cunningham


message

I have a Combo box selecting products in a
customer price-list.

The columns displayed in this combo box
are:

'ProdID', 'Unit', 'Description',
with ProdID as the bound column.

But I want the Combo to display in the
order:

'Description', 'Unit', 'ProdID'.

(With the ProdID as the bound column as
before.)

I need to use the 'Description' as an
autolookup.

For some reason I cannot make the Combo
display the columns in this second
arrangement.
I have tried rearranging the columns in
the underlying query which is:

***
SELECT Products.ProdID, Products.Unit,
IIf(Val([Unit])=0,1,Val([Unit])) AS Expr1,
Products.Description,
Products.ProductGroup

FROM Products

WHERE (((Products.ProductGroup)<>"S" And
(Products.ProductGroup)<>"B" And
(Products.ProductGroup)<>"EQ"))

ORDER BY Products.Description;
***

The Combo is in a subform linked via
customer.

Please help, Frank