Retaining "All" in combo box

[toni.gee]

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?

 

[Dave Miller]

Try this site:

http://www.fabalou.com/Access/Forms/comboboxextrarow.asp

David Miller

 

[PCLady]

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.