Listview and multiple tables?

[davyboss7]

Hi, this is my first thread and I'm pretty new to vb6.

At present I'm working on a search function using a listview.

Could someone tell me if there's a way to use multiple tables to populate the listview.

Heres my atttempt.

Private Sub Form_Load()
Call Connect
check_rs
rs.Open "select * from music", cnn
rsPub.Open "select * from Publishers", cnn

fill_list
End Sub


Public Sub fill_list()
ListView1.ListItems.Clear
If rs.RecordCount = 0 Then Exit Sub

While Not rs.EOF

Set lst = ListView1.ListItems.Add(, , rs(0))
For eX = 1 To 12
lst.SubItems(eX) = rs(eX)



Next eX
rs.MoveNext

Wend
End Sub

No joy though. Error 3265.

[Static]

Public Sub fill_list()
    ListView1.ListItems.Clear
    Dim lst As ListItem
    If rs.RecordCount = 0 Then Exit Sub
    
    While Not rs.EOF
        
        Set lst = ListView1.ListItems.Add(, , rs(0))
        For eX = 1 To 12
            lst.ListSubItems.Add , , rs(eX)
            
        Next eX
        rs.MoveNext
        
    Wend
End Sub

[davyboss7]

Thanks mate I'll try that!