Appending a default item to dropdown?

[SirPoonga]

I am setting the rowsource of a dropdown box with a SELECT statement.
Is there a way to have a sorted list of data (via ORDER BY) in the drop
down and then append as the first option some default option. Say I
want to append "NONE" as the first option, then the rest ordered
alphabetically so NONE doesn't appear in the Ns.

 

[Ken Snell [MVP]]

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0043.htm