Syntax Error (1 Viewer)

[violentjay25]

I cannot figure out what is wrong with the code below. The first text box txtProjectName is NOT a date. I know the # sign does not belong there but I borrowed this code from a working form and modified the field names hoping it would work. Any Suggestions. HELP!!!!!!!!!!!!!!

DoCmd.RunSQL "Insert into tbl_Projects (ProjectName, SystemsImpacted, SPRNum,ReleaseDate, Status, CSIPM, BPM, Implemented, StakeHolder, IBR1, IBR2, IBR3, Objective, SMERequirments, Phase) " & _
"Values (#" & Me.txtProjectName & "#, '" & _
Me.TxtSystemsImpacted & "', '" & _
Me.txtSPR & "', '" & _
Me.txtReleaseDate & "', '" & _
Me.CboStatus & "', '" & _
Me.txtCSI & "', '" & _
Me.txtBPM & "', '" & _
Me.cboImplemented & "', '" & _
Me.cboStakeholder & "', '" & _
Me.cboIBR1 & "', '" & _
Me.cboIBR2 & "', '" & _
Me.cboIBR3 & "', '" & _
Me.txtObjective & "', '" & _
Me.txtSMERequirements & "', '" & _
Me.cboPhase & "')"

 

[Crilen007]

Where does it error?

 

[Crilen007]

Err, are you sure the # isnt causing a problem? also, I think Releasedate should have #

 

[violentjay25]

The pounds signs do not belong

If I put a date in txtProjectName it works so I know that is the problem.