RUNSQL problem in ADP Form

[Farzam]

Dear all,
I have a project back end SQL SERVER front end ADP access
I want to run this SQL statement but iam faild to.
i dont know what is the problem

--------------------------------------------------
Dim SQL As String

SQL = "INSERT INTO Forecast_NEW_TEMP_Table" & _
"(CRIS_NO,Quarters,Years,Amount,YearAFG,Start_Qrt,qtr,qtrn,qrtstart)" & _
"SELECT CRIS_NO,Quarters,Years,Amount,YearAFG,Start_Qrt,qtr,qtrn,qrtstart FROM ForeCAST_NEW_Pipeline" & _
"WHERE CRIS_No = " & Me.CRIS_No

DoCmd.RunSQL SQL
--------------------------------------------------
Note Iam running this on an After Update of a text box in current form and the where condition checks the number in current form
please check and correct it

regards,

 

[Remou]

You are missing spaces in the SQL. It would be best to Debug.Print to the immediate window and check the syntax. The dedicated forum you want is forum958.