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

[Guest]

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

 

[Bob L.]

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.

 

[Guest]

Check this link on "Adding "All" to a listbox or combobox"

http://www.mvps.org/access/forms/frm0043.htm

 

[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.

 

[Guest]

Thanks. I will try all 3 options once my ODBC connection is working again.