Hi There, hope you can help!

In my application I have a listbox listing select criteria with the following code -

(VB Code -

adoExpertise.Open "select * from tblExpertise INNER JOIN tblExpertiseRequirements ON tblExpertise.bytExpertiseCode = tblExpertiseRequirements.bytExpertiseCode where tblexpertiserequirements.lngVacancyID =" & FrmVacancy.txtFields(0).Text, db, adOpenStatic, adLockOptimistic
List2.Clear

Max = adosecondary.RecordCount
adoExpertise.MoveFirst
List2.Clear

For i = 1 To Max
List2.AddItem adosecondary!chrExpertise
adoExpertise.MoveNext
Next i

end code)

My problem is how to delete the selected item from the recordset when the item is removed from the list box by the user - Can anybody hep?


Thanks in advance

- PB