Hi, i am having a problem with the statement below.
StrSQL = "DELETE * FROM tbltreatment WHERE treatmentid=" _
& Me.lstthreading.Value & ";"
CurrentDb.Execute StrSQL
The error message i get is syntax error(missing operator) in query expression 'treatmentdid='.
any help is much appreciated
StrSQL = "DELETE * FROM tbltreatment WHERE treatmentid=" _
& Me.lstthreading.Value & ";"
CurrentDb.Execute StrSQL
The error message i get is syntax error(missing operator) in query expression 'treatmentdid='.
any help is much appreciated