value not found in listview

[luca90]

Why code in Command2, dont find "California" in column 3?????

Private Sub Command2_Click()
    Dim oItem As ListItem
    Set oItem = Me.ListView1.FindItem("California", lvwSubItem, 3)
    If Not oItem Is Nothing Then
        MsgBox "The Record ID returned is: " & oItem.Text
        Set oItem = Nothing
    Else
        MsgBox "No Items Found"
    End If
End Sub

[DataMiser]

Because that value is not in sub item 3

The first column is the Text of the list view item the second column is SubItem(1) and the next is subitem(2)

So you are looking in subItem(3) which contains only numbers where the value you are tryign to find is in SubItem(2)

[luca90]

Because that value is not in sub item 3

The first column is the Text of the list view item the second column is SubItem(1) and the next is subitem(2)

So you are looking in subItem(3) which contains only numbers where the value you are tryign to find is in SubItem(2)

but i need search directly only in column 3 the value"California"... and not in all item of listview.
can you change my command button code, for that?
Tks.

[LaVolpe]

FindItem can search the subitems, but not a specific subitem. Also, if searching anything other than the .Text property, partial matches of the search criteria is not allowed, only exact matches. The problem you have is that you are telling it to start at the 3rd listitem, California is in the 1st listitem. The Index is not the subitem index, it is the index to begin searching from.

Since the lvwSubItem option doesn't allow you to specify which subitem to search in, you'll need to test if what was found was in .SubItem(2). The match could theoretically be in another subitem

[stum]

Hey,
Check this post, it may just be what you're looking for.

http://www.vbforums.com/showthread.p...=1#post4797799