 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / December 2007Alphabetical List Box
I am linking Infopath to Access and want to be able to use a drop down list box to query the rest of the address information for clients. How can I make my drop down list alphabetical. Even though I am searching by the business name, the names are sorted by the autonumber assigned by access. When working with a database connection, the easiest way is to modify the data conection query string to return a sorted list.  SignatureGreg Collins Microsoft MVP Visit Braintrove at http://www.braintrove.com Visit InfoPathDev at http://www.infopathdev.com Open Data Connections Where you table is selected and the field are displayed with checks Look on the lower right and use the edit SQL button. Add an "Order By Address" or whatever the field name is and that will alphabetize a-z SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > I am linking Infopath to Access and want to be able to use a drop down list > box to query the rest of the address information for clients. How can I make > my drop down list alphabetical. Even though I am searching by the business > name, the names are sorted by the autonumber assigned by access. Thanks Clay for the specific steps! SignatureGreg Collins Microsoft MVP Visit Braintrove at http://www.braintrove.com Visit InfoPathDev at http://www.infopathdev.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.