Delete record and Error 3075

[Opal]

I am running Access 2003 and I want the user to
be able to "uncheck" a text box and click a button
so that the record is removed from the table. I
was hoping to use something like this:

Dim strQuery As String
strQuery = "Delete MSDef " & _
"WHERE MSResponse = 0"

CurrentDb.Execute strQuery, dbFailOnError

But I get a Run-time error 3075

Syntax error (missing operator) in query expression 'MSDef
WHERE MSResponse = 0'.

Can someone help me with a solution? Thank you.

 

[Douglas J. Steele]

strQuery = "Delete FROM MSDef " & _
"WHERE MSResponse = 0"

 

[Opal]

Thank you, once again, Doug....I new it was something
simple....I'm still learning