Hi all,

I have a list box where if I click on text in it the text gets removed from the list box.

Now the problem is...

The lstbox is filled with data that must be saved to a record. I use a for do loop..
for i = 1 to lstBox-1 do
lstBox.listIndex = i
data1.recordset("stuff") = lstbox.text
next i

Now when the line lstbox.listindex is executed the computer somehow goes to my lstbox_Click sub. How do I stop it from throwing this click event while still setting the listindex to i. the problem is that when it goes to the click event the text is removed and then lstbox.text is empty.

help anyone
thanks in advance