Hi,

Well, now the item is deleted from the ListView, but it won't be deleted from the Table.

VB Code:
  1. RSLevels.Open "Select ID From Levels Where ID=" & Val(ListView1.SelectedItem.Key), Conn, adOpenDynamic, adLockOptimistic, adCmdText
  2.  
  3. With RSLevels
  4. If Not (.BOF = True Or .EOF = True) Then
  5.         .Delete
  6.          If Not (.BOF = True Or .EOF = True) Then
  7.         .MoveNext
  8.          If .EOF Then RS.MoveLast
  9.         .Update
  10.         .Requery
  11.         .Close
  12.         End If
  13.         End If
  14. End With
  15.  
  16.     If ListView1.SelectedItem.Index <> 1 Then
  17.     ListView1.ListItems.Remove ListView1.SelectedItem.Index
  18.     MsgBox " Item Deleted", vbExclamation, "Delete Item"
  19.     End If

Any Help ????????

Thanks,
Habibalby