Sort ascending in drop down

[Cloey]

I have an infopath form that I use an access database table for drop down
boxes. When I update the information in the database, I sort ascending,
however when I open the form the drop down box does not sort ascending. The
most recent additions are at the top not in alphabetical order. Can I fix?

 

[S.Y.M. Wong-A-Ton]

Is a primary key set on the database table?

 

[Cloey]

No.

Is a primary key set on the database table?

 

[S.Y.M. Wong-A-Ton]

Try adding one and see if it helps.

 

[Cloey]

Didn't make a difference.

Try adding one and see if it helps.

 

[S.Y.M. Wong-A-Ton]

Try opening up the data source connection for the dropdown list box (Tools >
Data Connections) and edit the SQL statement for the data connection to
include an ORDER BY clause if it does not currently have one.

The last thing you could try to do is sort using code, but that would be
going a bit over the top...

 

[wina]

I just found out last night. If u want to sort only a field:
1. Select DATA CONNECTION
2. Select the database and click on MODIFY
3. Select MODIFY TABLE
4. SORT ORDER dialog box will appear and select the field u wish to
sort
It works for me since mine is simple.

 

[S.Y.M. Wong-A-Ton]

Cool tip, wina! Hopefully it will solve Cloey's problem. Thanks!