Delete SQL statement not functioning
0
I receive “Syntax Error in FROM clause” Any help/ideas are greatly appreciated, I’m a beginner if you can’t tell! CODE is as follows: Private Sub cmdDelete_click() Dim sql As String, rCount As Integer If me.dirty then Me.dirty = False End if Set dbs = currentdb SQL = “DELETE Item FROM item = ‘“ & me.txtItem & “‘“ & “WHERE ID=“ & me.txtID2 Dbs.Execute sql, dbFailOnError rCount = dbs.RecordsAffected If rCount >0 then Msgbox “The item List has been updated” List40.Requery Clear End if End sub
sql ms-access
share | improve this question
edited Nov 21 '18 at 9:44