Alphabetical List Box

C

CCF

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.
 
G

Greg Collins

When working with a database connection, the easiest way is to modify the
data conection query string to return a sorted list.
 
C

Clay Fox

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
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Web - Sorting Calendars by Alphabetical order? 0
How to make repeating drop-down lists? 2
Link a text box based on drop down box with four options MS Word 365 0
MS Project Center-Autolink column fields 0
Drop down lists in seperate columns 5
Drop down list control value in vba 2
Dynamic Naming of Form Button 3
Set as Default Template not working 0

Top