List box question

[cannonenter]

I have a application that i want to search through a list box and then go and find all the information about the entry held within a access database.

My question is how do i loop through the list box 1 by 1 with out clicking on each entry.

Many thnks

Stephen rattray

 

[ZOR]

Use a loop.
For TT=0 to List1.Listcount-1
List1.Listindex=TT
' Use the List.Text or List Itemdata to do what you want with
Next TT

 

[johnwm]

For a = 0 to List1.Listcount - 1
Msgbox List1.List(a) ' or do what you want here
Next


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'