missing operator on a delete query

[kes]

hi,
I'm trying to find a solution for this without success...
I bet is rather simple and I'm missing it...

I have this code:

CurrentDb.Execute "DELETE FROM Type WHERE Project_ID =" & Me.Project_ID & " & AND (Type = '" & Me.Txt_Type & "')"

and I'm getting this error message:

Syntax error(missing operator) in query expression 'Project_ID = AND (Type = 'Webinar')'

hope you can help...

 

[spikepl]

http://www.baldyweb.com/ImmediateWindow.htm

 

[pradeepiyer]

Try this:

CurrentDb.Execute "DELETE FROM Type WHERE Project_ID = " & Me.Project_ID & " AND [Type] = '" & Me.Txt_Type & "'"

 

[kes]

thanks!!! worked!

 

[pradeepiyer]