UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Combo Box - none    
 
   
hottamale
post Nov 28 2008, 05:19 PM
Post #1

UtterAccess Addict
Posts: 211
From: The Isle of Long, NY
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
Go to the top of the page
 
+
ace
post Nov 28 2008, 05:44 PM
Post #2

UtterAccess VIP
Posts: 5,279
From: Upstate NY, USA
Same way. Just add it to the rowsource string.

.RowSource = "(All);(None);" & .RowSource
Go to the top of the page
 
+
hottamale
post Nov 28 2008, 05:52 PM
Post #3

UtterAccess Addict
Posts: 211
From: The Isle of Long, NY
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. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Go to the top of the page
 
+
ace
post Nov 28 2008, 06:03 PM
Post #4

UtterAccess VIP
Posts: 5,279
From: Upstate NY, USA
Same answer. Do it the same way you did with "(All").
Add another Union Select statement to the query.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 08:52 PM