I have a list/menu on my search page that is populated by an access table called categories. I entered all the initial categories alphabetically, but now I want to add some new ones. The problem is the new categories get added to the bottom of my list/menu and I want them listed in alphabetical order. I tried using the sort function in access, but it has no impact on the way the list/menu appears.

Does anyone know if there is a way to do this. Thanks in advance for any advice.

A bit more searching and I found the answer I needed. This tutorial www.ultradeviant.co.uk/tutorials/tutorial.asp?view=sort_p1 gave me the clues I needed.

For anyone else who is interested, all I had to do was add the "ORDER BY Category" statement to the SQL section of my recordset. I knew it had to be easy<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

You have one other option... you can create a query and have the query order the list and then have the record set for the list/menu call that query which already has ordered the list prior to calling it to the client.... I find that letting the database do what it is designed to do as well as the database being on the sever side... you have less overhead on the network which provides you with better response for your users.



Wm. Kent Steelman