It because there is no SubItems(3) in your listview..
And why you show Owner ID twice in all of your codes?
modified as following "Set lst1 = lvStudentInfo.ListItems.Add With lst1 .Text = rs!Owner_ID .SubItems(1) = rs!Owner_Name .SubItems(2) = rs!Owner_Address End With
Oh! Thank you sir! It works. :)