Hi Craig,
Just want to let you know I figured it out by using an old David Powers book on Dreamweaver 8. It works when I use the insert menu and go to insert>data objects>dynamic>lists/menu. My recordset uses orderby. So that worked.
Thanks for all your help.