The is an option to sort the Combo Box in the wizard.
You can also edit the Row Source and add an Order By clause.
SELECT ID, FieldName FROM TableName ORDER BY FieldName;

Hello Kevin again.   Thanks!  For some reason I could not sort in combo bow with wizard.

I did not make myself clear, I think. Sorry. The Table AuthorT is used as a Combo Box field source for another Table, BookT.   Right now, we are beginning to categorize many hundreds of these Books. They are all books about Freemasonry.  There are a limited number of Authors who wrote these books throughout the last three hundred plus years, maybe about 150 authors.  Many Authors wrote 5 to 20 different books each.   I use a Form to update the AuthorT field.   Some of these books by an Author, are printed in different languages and different counties.  Some analysis is required by the user at that time.  I'm hoping that using the Form, AuthorF, I can enter names into the table AuthorT and that the table will be sorted before I enter a new Author to make sure that I don't add the same Author's name twice.  Remember, the info in the book may be in a different language or printed by a different Publisher that looks slightly different then another book written by the same author.    It would be a great help to see the Authors in a sorted order while trying to add what we think might be a new Author/book.

To sort the records by Author in a Continuous Form set the Record Source of the Form to an SQL statement.
I put together an example for you (see screenshot). The code also checks for duplicates.

Check out these videos for more info:
Intro to VBA
Before Update
After Update
AfterUpdate & DLookup
DLookup
NZ Function
If Then
MsgBox

Thanks that really worked and now I understand.