Adding "None" and "More..." to a combobox

[J Holtendehouzer]

I have a long list in a combobox, but only a few are common choices. What
I'd like to do is have an alphabetical list of options (from a table), but
I'd like to have a "None" option at the top and a "More..." option at the
bottom (which would modify the rowsource to include all the choices, not
just the common ones).

Is that possible? I've tried using UNION queries, but I can't get the list
to be alphabetical except for the two extra options.

Thanks!

 

[John Vinson]

I have a long list in a combobox, but only a few are common choices. What
I'd like to do is have an alphabetical list of options (from a table), but
I'd like to have a "None" option at the top and a "More..." option at the
bottom (which would modify the rowsource to include all the choices, not
just the common ones).

Is that possible? I've tried using UNION queries, but I can't get the list
to be alphabetical except for the two extra options.

Thanks!

The trick to sorting a UNION query is to put the Order By clause in
the LAST SELECT statement - it orders the entire recordset. Therefore
you may want to use

_More
_None

or some other character prefixing the option, so that the special
terms don't sort in the middle of the alphabet.

John W. Vinson[MVP]