Sort Order in drop down box

[DebbieV]

Can you tell me how to change the order in which items are displayed in a drop down box? I used the lookup wizard to create the drop down box and its puts the items in asending order rather than the order I typed it in in the table. I looked in the help file and it tells me to type the "fieldnameDESC" to change it to desending order in the properties OrderBy. I did this in the table but I can't seem to find a OrderBy property in the form to do the same. any suggestion will be most helpful.

Debbie

 

[ColinEssex]

Debbie

In the ComboBox properties look for the 'Row Source'

Then click on the little grey button to the right with the 3 dots on it ... this gets you to the query grid behind the ComboBox, you can then specify the sort order in the normal way for a query.

Hope this helps

Col

 

[DebbieV]

Oh Colin,

It worked great, you won't believe how long I worked on this yesterday to try to changed this sort. THANK YOU VERY VERY MUCH.

Debbie

 

[ColinEssex]

Your welcome, glad to be of help.

Col

 

[David R]

Not to step on Colin's toes..

But another tip is if your combo is based on a SQL statement, instead of a saved query, you can get it to run faster if you actually save the query. When you go into the [...] view of the SQL, you can Save As just like any other query. When you exit that window it will show the name of your new query instead of "SELECT ....."