Combo Box - Specifying Sort Order

[Jim Mac Millan]

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

 

[Larry Linson]

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