Combo Box

[Crispy]

I have a combo box in a CD database and I am unable to get the box to show
the artist names in alphabetical order!

Any ideas how I can get the box to show the artist nakes in the right order?

Thanks

 

[Rick Brandt]

I have a combo box in a CD database and I am unable to get the box to show
the artist names in alphabetical order!

Any ideas how I can get the box to show the artist nakes in the right order?

Presumably the RowSource of the ComboBox is a named query, a table, or a SQL
statement. In either case you can press the build [...] button to the right of
the RowSource property and the query builder will open up where you can specify
whatever sort order you want on the query.