i have a dbcombo on a form and wish to use it to delete a user. Now everything works fine except for the deleterecord function that i have. Can someone suggest what is wrong with my code :
Dim mySQL As String

If MsgBox("Are you sure you want to delete the selected record?", vbQuestion + vbYesNo, App.Title) = vbYes Then

mySQL = "DELETE * FROM [Password] WHERE PassID = DBCAccounts2.text"

pDatabase.Execute mySQL

End If

now it gets stuck at pdatabse.execute mysql
thanx in advance for anyone who helps
Mike