LIST BOX

[ashraf_al_ani via AccessMonster.com]

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

 

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

 

[Linq Adams via AccessMonster.com]

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