[stirlsa]

In Access 2007 I have a combo box that is within a subform and a form.

In the combo box:

My Row Source is a Table called Issue ID.

My Control Source is called IssueIDJct. I cannot tell where I got it other than I know that IssueIDJct is is a field inside a table called CallidJunct. It is important because that is my junction table that handles a complex relationship.

Funny thing is that the multiple items that a user selects from the combo box alphabetize just fine.

The part I cannot get to alphabetize is the combo box drop down.

[Ziggy1]

IssueIDJct is where your selection goes from your combo box.

The easiest thing to do is make a query based on the table and sort your records as you want them, then select the query as your row source.

another way is with SQL but you don't need to know SQL, when you are in form design go to the properties of the Control's "Row Source" clear out what is in the field and click the Build button ( 3 dots ...) this will open the query builder, you can add your table and then sort your fields accordingly ( put the field you want to see in the combo as the 1st column)...then DON'T save just close the query design...it will ask if "you want to update the changes made to the SQL statement and update the property"...click YES and you will now see a "Select" statement in your Row source.

[stirlsa]

Thanks - I used the Row Source. It worked.