Full Version:
Combo Box - none
UtterAccess Discussion Forums
>
Microsoft® Access
>
Access Forms
hottamale
Nov 28 2008, 05:19 PM
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
Nov 28 2008, 05:44 PM
Same way. Just add it to the rowsource string.
.RowSource = "(All);(None);" & .RowSource
hottamale
Nov 28 2008, 05:52 PM
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.
ace
Nov 28 2008, 06:03 PM
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
.