ROW SOURCE-FORM COMBO BOX TO INCLUDE 'ALL' LISTED VALUES

K

Karina M ;)

I want to add an "ALL" value that includes all of the listed values. How
would I do this?
Thanks.
 
B

Bob L.

* Karina M ;) said:
I want to add an "ALL" value that includes all of the listed values. How
would I do this?
Thanks.
For a combo box, one way would be to simply include an ALL in your row
source table and then include code to deal with it, eg a select case for
"ALL", etc.

If you can use a list box instead, then you can set the Multi-Select
property to extended, allowing users to use shift and control to select
as many of the values as they want.

Bob L.
 
S

storrboy

I want to add an "ALL" value that includes all of the listed values. How
would I do this?
Thanks.


Just remove any filtering or Where claues when the box is empty.
Adding an 'All' to a combobox that gets it's values from a table or
query is somewhat complicated.
 
Top