LIST BOX

Dear All
I have a list box that previhe listews valuse 1,4,5,6...

is there a way to apply a condition to this list by saying
if one value of the list box is 1 then do a condition??
or if the list has a value 4 then do another condition??


i mean i want to apply a conditions to the listbox according to its values

best regards

--
Message posted via http://www.accessmonster.com

Select Case Me.ListBoxName
Case 1
' Do something
Case 4
' Do something else
Case 5
' Do another thing
etc.
End Select

However, this is not practical if there are many possible choices, in which
case it would depend in part on what you want to do, and the connection
between the list box values and that action.

By the way, "previhe listews valuse" is not meaningful.


ashraf_al_ani wrote:
Dear All
I have a list box that previhe listews valuse 1,4,5,6...

is there a way to apply a condition to this list by saying
if one value of the list box is 1 then do a condition??
or if the list has a value 4 then do another condition??

i mean i want to apply a conditions to the listbox according to its values

best regards

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

Also note that Bruce's code would go in the Listbox AfterUpdate event.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1