Order of records in query problem

[EddyLLC]

I have a combo box on a form. It contains the line numbers for a specific invoice. the control source is aa query from a table. I want to view the line numbers in Descending order(Highest number to smallest number). When I run the query alone it looks fine. When I use the combo box on the form the order of the invoices is mixed up. For example, top to bottom in the combo box will be 2,3,4,1. Is there a way to have them appear in the combo box the same way they appear when I run the query independently, descending order?

 

[PHV]

What is the SQL code of the RowSource property of the combo ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EddyLLC]

Thanks for the response PHV. When I looked at the SQL I notice there was no ORDER by in it. Problem solved. Thanks for the headsup.