Remove Selected item from database when removed from listview(Resolved -Thanks!!!!! )

[altf4]

Hi All

Need a little help with this one, I am trying to write code to remove a selected item from the database when the user selects an item in the list view and here is what I have so far

Dim adoRemove As Recordset

Dim vacancyid As String
Dim code As String
vacancyid = Form7.txtFields(0).Text
code = ListView1.List(ListView1.ListIndex)

Adoremove.open = "select * from tblrequired requirements where lngvacancyid = " & vacancyid And bytcode = code ,db, , adOpenStatic, adLockOptimistic

.Delete
.Close

I have two columns in the listview and I want to the sql statement to get the value from the 2nd column in the listview for the selected item

Can you help me?

Thanks in advance