Access 2000 Combo Box Alphabetical Listing and Coding

[Guest]

Hello,

I am working on creating a database with forms for data entry of customer
information (name, ID, addresses, reservations, lodging, etc).

My problem is that the drop-down menu of all of my combo boxes do not list
the categories in alphabetical order. I read a post that suggested including
"ORDER BY" in the row-source parameter of combo box properties. However,
this did not work for me b/c the software did not recognize the command.
Does anyone know how to alphabetize combo box lists in Access 2000?

In many of the discussion posts, I see long streams of coding used for
various applications. When using the Access software, where can I type/use
these codes? I do not plan on relying on wizards--I'd rather have more
control.

Thank you,
DianaS

 

[Guest]

On the RowSource Property of the combo, enter the SQL and select the sort you
want in that SQL
Select FieldName From MyTABLE Order By MyFieldName