Access 2000 Combo Box Alphabetical Listing and Coding

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top