https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/21605.aspxWed, 11 Jul 2007 05:44:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21605Ted Fitch0https://www.infopathdev.com:443/forums/thread/21605.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=21605<p>Hi JR,&nbsp;&nbsp;</p><p>Have you tried modifying the default view in SharePoint and making that list sorted by the column you want A-Z?&nbsp; I think the drop down populated by ShP is going to take the ordering of the columns in the list from SharePoing in the default view.</p><p>Hope that helps</p><p>Ted</p>https://www.infopathdev.com:443/forums/thread/21579.aspxTue, 10 Jul 2007 06:08:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21579JRPoole0https://www.infopathdev.com:443/forums/thread/21579.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=21579<p>Hi,</p><p>&nbsp;I have reated a data connection from a sharepoint list.&nbsp; I use this list to populate 3 dropdown controls.&nbsp; Is there any way to get the list sorted a-z.&nbsp; When I connect to a database sources I can use sql and there is no problem but there does not seem to be a way with sharepoint lists to do this.&nbsp; If anybody has a answer I would appreciate it.</p><p>JR</p>