Hi Everybody,

I have a combo box with two columns. Column 1 is a number and Column 2
is text.

Is there any way to have the combo box sort column 1 in descending
order? The wizard doesn't seem to have an option to change it from
ascending.

TIA
Jim Mac Millan

"Jim Mac Millan" wrote

> I have a combo box with two columns. Column 1
> is a number and Column 2 is text.
>
> Is there any way to have the combo box sort
> column 1 in descending order? The wizard
> doesn't seem to have an option to change it from
> ascending.

You've already, clearly, used the Wizard. Now replace the RowSource with
either a Query or SQL Statement that does exactly what you want. I'd
suggest using the Query Builder, and just setting the Sort property of the
numeric field to Descending. If you want to use SQL, copy the SQL from the
Query Builder's SQL View, and simplify it, if you'd like.

Larry Linson
Microsoft Access MVP