Full Version: Combo Box - none
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
hottamale
Hi again...

Thanks to this post I have added (All) as a selection in my combo box.

I'd also like to add (None)

How do I do this, please?

Thanks.
Michele
ace
Same way. Just add it to the rowsource string.

.RowSource = "(All);(None);" & .RowSource
hottamale
Actually, I did it with the Union Query...

UNION Select Null as AllChoice , "(All)" as Bogus

Do I just add None? How does it know the difference?

Thanks for responding. sad.gif
ace
Same answer. Do it the same way you did with "(All").
Add another Union Select statement to the query.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.