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

  • Thread starter Thread starter J Holtendehouzer
  • Start date Start date
J

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!
 
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!
Click to expand...

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