Delete Error

[Eranka]

HI

CurrentDb.Execute "DELETE * FROM tblUser WHERE [ID] = '" & Me.Combo4 & "';"

when i run the above code i get "data type mismatch error"

tblUser ID datatype number
Combo4 = number.


how to ignore the above error? any changes to be done for the above code?

[CJ_London]

if they are numbers, you don't need to text qualifiers.

…..[ID] = " & Me.Combo4

FYI, you don't need the semi colon either