ListView Question

[Ace]

Hi Everyone,

I have added check boxes to the first column in a ListView. What I would like to do is this, when a user selects or deselects any one of the check boxes in the column I want a sql statement to execute. Any ideas on how to do this? I would appreciate any help. Thanks.

[Danial]

Just use the ItemCheck event.

[The Hobo]

Private Sub ListView1_ItemCheck(ByVal Item As MSComctlLib.ListItem)
  MsgBox Item.Text
  'code to do something here
End Sub