Delete Syntax problem

[hardrock]

Hi all, can someone please help me get the syntax below right?
I'm loading the values of 2 text boxes, tabl and text10 from my form into the statement.

Many thanks

db.Execute "DELETE * FROM " & Me.tabl & " WHERE ID = ('" & Me.Text10& "');"

 

[EMP]

If the table name may contain spaces or special characters, add the square brackets.

If ID is a numeric field, remove the single quotes. Don't think you need to put the ID value in brackets.

db.Execute "DELETE * FROM [" & Me.tabl & "] WHERE ID = " & Me.Text10 & ";"

^