Try these 2 FAQ topics:
Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list?
Now that my LOV lets me use ALL for all values, how do I get the ALL in the list?
BoB LoblaW 
(BOB member since 2007-10-23)