Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sort ascending in drop down

109 views
Skip to first unread message

Cloey

unread,
Jul 7, 2006, 9:04:01 AM7/7/06
to
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

unread,
Jul 7, 2006, 1:06:01 PM7/7/06
to
Is a primary key set on the database table?
---
S.Y.M. Wong-A-Ton

Cloey

unread,
Jul 7, 2006, 1:11:02 PM7/7/06
to
No.

S.Y.M. Wong-A-Ton

unread,
Jul 7, 2006, 1:29:02 PM7/7/06
to
Try adding one and see if it helps.

Cloey

unread,
Jul 7, 2006, 2:28:01 PM7/7/06
to
Didn't make a difference.

S.Y.M. Wong-A-Ton

unread,
Jul 7, 2006, 2:56:02 PM7/7/06
to
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

unread,
Jul 8, 2006, 11:30:18 AM7/8/06
to
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

unread,
Jul 9, 2006, 10:50:01 AM7/9/06
to
Cool tip, wina! Hopefully it will solve Cloey's problem. Thanks!
---
S.Y.M. Wong-A-Ton
0 new messages