https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/2945.aspxMon, 07 Aug 2006 17:17:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2945Greg Collins0https://www.infopathdev.com:443/forums/thread/2945.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2945I know with a SQL connection (and I would assume that its the same with Access) that you can go to the data connection, and edit the SQL code that retrieves the data and add the sorting right there... That way the data comes down from the database already sorted.https://www.infopathdev.com:443/forums/thread/1477.aspxSat, 05 Aug 2006 08:02:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1477ciredon0https://www.infopathdev.com:443/forums/thread/1477.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1477Hello.<br /><br />I have a drop-own list box that gets its list from secondary database (Access). My problem is how can I sort the list being displayed in my InfoPath form?<br /><br />I sorted the Access database based on how I want is to display in the list box yet when I preview the form it is not sorted. By the looks of it the arrangement being displayed is the sequence on how I inputed the values initially in the Acces mdb.<br /><br />Is there a way to resolve this through rules? If not can you give a sample code to resolve this.<br /><br />Thank you in advance.