Retaining "All" in combo box

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

Guest

I use the following code as the row source in a combo box:

SELECT [Months].[MonthNo], [Months].[Month] FROM Months UNION Select Null as
AllChoice, "(All)" as Bogus From Months ORDER BY [Months].[MonthNo];

The combo box works fine and produces the correct results (which are then
utilised by a query). However, after selecting (All), the dropdown list
disappears (as normal) and the combo box shows blank (null).

Is there a way to make it show (All) to reinforce that this was the
selection made?
 
Hi Dave,

I applied the suggestions to my my combo box and it did work! My question
is I need to display all the countries once "Select All" is chosen, what
would be the best way to achieve this.

Thanks in advance for your feedback.
 
Back
Top