i am using this code in updating multiple data in listview but it doesn't work, what code should i replace to run this command save

        sample RS.Open "Select * from table where field = '" & listview.listitem & "'", , conn, adOpenKeyset, adLockOptimistic
                If RS.RecordCount = "0" Then

A SELECT statement only reads information; it does not update anything. There is a lot of code missing around this that is needed to actually do anything useful. Please post more complete code (that will actually compile) or post the error message when you try to compile.