properties - VB6 Listview MultiSelect Property Code -

First of all, I have created a list view that is on full selection but it only selects an item with listview . Here's my code, how it works, the user clicks the item in the list view, and then it will reduce the amount from the list. It is very one item after all of a click that if I click tired for many items

  y = ListView3.SelectedItem.SubItems (4) ConnectDB rs.Open "Select from the list where * ProductNumber =" & amp; Y, database, 3, 3 rupees (5) = txtStockLeft rs.Update set rs = nothing db.Close: set db = nothing ListView3.ListItems.Remove ListView3.SelectedItem.Index  

So I learned that, the list view contains multilevel assets, you can select multiple items and then press the command. And I do not know about how this code is. Any help would be appreciated.

  Edited for Alex. Here is my code. I have the update area on txtStockLeft, but put the error  
  Personal sub command1_Click () ListView3.ListItems in each of Lee's For ConnectDB dim Li listItem then li.Selected then '// is selected item txtStockLeft = listview 3. Selected ITEM SUVITS (3) DB.Execute "RS (5) =" & amp; TxtstockLeft & amp; "Where ProductNumber =" & amp; Li.SelectedItem.SubItems (4), adcmdText end then next db.Close: set db = nothing End Sub  
 
 method or data member is not found to be an error, and Error highlights the txtStockleft 
 

in the code or property window you need ListView3.MultiSelect = True

You can simply select ctrl / shift / click and select, then there may be a problem in a button event (due to a list view click mismatch):

< Pre> each as Connectible DIL If Lee ListItem ListView3.ListItems to the Minister. If set, set the "// item db.execute selected" update list ????? = "& amp; TxtstockLeft & amp; "Where ProductNumber =" & amp; Li.SelectedItem.SubItems (4), adcmdText end then next db.Close: set db = nothing

this avoids the SQL method Potentially expensive full table you can read Are currently, just replace ????? with update field name.

(Also make sure txtStockLeft is valid)