Listbox - update query

[jammerdk]

Hi

I'm having a listbox (lstbox1) containg a valuelist
now i'm trying to run thru the entire list by clicking on a command button and then parse each value to a update query

can it be done ?

 

[HarleyQuinn]

Well to loop through the ListBox and get the values you would use something like:

Dim i As Integer

For i = 1 To lstbox1.ListCount - 1
    Debug.Print lstbox1.ItemData(i)
Next i

For each value you could then run the Update query using the returned value.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[TheAceMan1]

How are ya jammerdk . . .

You need to be more specific or provide an example.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jammerdk]

Thanx HarleyQuinn you guiding me in the right direction )