Arrays and grid

[AFK1]

When I loop through my array in same application 2nd time, then it boms and gives error Subscript out of range (Error 9).
I loop through array when someone clicks the grid. First time , grid click works fine. then when I click on a Button to get someother info and then click on grid again it boms.
Can someone help please..

 

[WZUP]

Could you show some code example, we would have a better ideal of your problem.(ie. not resetting you loop counter)

 

[AFK1]

i=0

vBookmark = (CInt(grd.selBookmarks(iRow)))
sItemID=vBookMark
'check if I have rows in my Grid array
If mlarrayMaxRows<> 0 Then
'Loop through rows
Do While i <= mlarrayMaxRows
'check if my second array value is same as grid array.
If Array(ITEM, i) = sItemID
---something here
If Not Array(QTY, i) Then
txtQty.Text = Array(QTY, i)
Else
txtQty.Text = ""
End If
cbo.Text = Array(LINE, i) + Space(5) + Array(ITEM, i)
Endif
i =i +1
Loop

So first click works. But when I click on something else, another button, and then click on grid again, I will get that error. Also in My save I call this subrooutine, and it boms too. My guess is the grid may looses focus. But how can i do that as in Save, no one has to click on grid, i just want to capture the bookmark of the row.

 

[strongm]

Which line does it bomb out on?

 

[jadams0173]

Looks like this thread again... thread222-1171566
Sorry AFK1 if I sort of started asking question in the thread. But hopefully now you can try the for next approach using LBound and UBound and stop getting the pesky subscript out of range error.

 

[AFK1]

No...Actually I though its not the array but may be its my grid.thats why i started new thread.

But just now I find out that during my call to thebutton, i was erasing my array.

thanks