Hello, eveybody.  I created a form (VB6) and I put a listview with checkboxes on it. This listview loads some records from a table (Access 2000).  So far so good !   So, after the records are displayed, I'd like to mark some checkboxes  and to check  in other table if this record exists. For instace :
Let's suppose I have two tables : A and  B. I show all of records from table A and after marking some checkboxes I'd like to check  if a specific record exists in table B. If it is True I'd do some changes in table A and after in table B. Just that !!   The property listview.selecteditem shows the item I selected and not the information about the record from some field. I'd like to refer a record from a specific field (column in DB).

Well, if someone could help me with some codes, some tips I'be thankfull.

JotaBeBr

I got it.  It is the property subitems from listview. Just for instance :

For i = 1 To ListView1.ListItems.Count
    
       If ListView1.ListItems(i).Checked = True Then
        a = a + 1
        
        Set MyRs = New ADODB.Recordset
        
        MyRs.Open "MyTable", conn, adOpenKeyset, adLockOptimistic
        MyRs.Find "MyField=" & ListView1.ListItems(i).SubItems(1), 0, adSearchForward, 1
        
   '  here goes other commands.....and so on
          
    End If
    
    Next


Even so,  thanks all.

JotaBeBR