Combo Box. Change row order?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Martin - 16 Mar 2008 01:01 GMT

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

Reply to this Message

Jeanette Cunningham - 16 Mar 2008 01:20 GMT

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

>I have a Combo box selecting products in a customer price-list.
>
[quoted text clipped - 30 lines]
>
> Please help, Frank

Reply to this Message

Frank Martin - 23 Mar 2008 03:13 GMT

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"
<nnn@discussions.microsoft.com> wrote in
message
news:%23$9UUuvhIHA.4196@TK2MSFTNGP04.phx.gbl...

> Frank,
> Row source query is:
[quoted text clipped - 68 lines]
>>
>> Please help, Frank

Reply to this Message