Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drop down list in alpabetic order

Status
Not open for further replies.

chasmith17

Technical User
Joined
May 25, 2006
Messages
47
Location
US
Hello,
I have a form that has a drop down menu and when I pick from the list it fills in the rest of the fields in the form. I can't get the list to display in alphabetic order. It seems to go in the order that I enter the records. I have changed the order in the table and it is fine there just can't get the drop down list to change. Thanks for your help.
 
Is this a drop down menu on the toolbar or a combo box on the form? (If a combo box, what's the row source for it?)
 
Hi Hakala,
It is a combo box and the row source is "SELECT Parts_OLD1.ID, Parts_OLD1.[Part desc], Parts_OLD1.[Varian part #], Parts_OLD1.Varian, Parts_OLD1.[Note:] FROM Parts_OLD1;" Hopes this helps.
 
Try
Code:
SELECT Parts_OLD1.ID, Parts_OLD1.[Part desc], Parts_OLD1.[Varian part #], Parts_OLD1.Varian, Parts_OLD1.[Note:] FROM Parts_OLD1
ORDER BY Parts_OLD1.[Part desc];


 
Thank you very much Hakala. That did it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top