Retaining "All" in combo box

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?
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Formatting 1
Combo Box - "<Select User>" 2
Adding "all" to combo box isn't working 3
select all 13
Combo Box Null 1
Undo a combo box selection 3
Prevent duplicate selection from combo box on continuous form 4
Setting a date field using combo box 3

Top