How do you put breaks in an UPDATE SQL to continue it on the next line (it's to long for the window)?
SQL$ = "UPDATE MoldList SET Rework = IIF(Me.Scrapped=-1,DATE(),"") ; Notes = IIF(Me.Scrapped=-1,Me.Reason,"") ; [LastRepair] = '" & Me.[LastRepair] & "' ;
[DL] = '" & Me.[DL] & "' ;[DLn] = " & Me.[DLn] & " ;[DO] = '" & Me.[DO] & "' ;[DOn] = " & Me.[DOn] & " ;
---------------------------------------- break -----------------------------------------
[CL] = '" & Me.[CL] & "' ;[CLn] = " & Me.[CLn] & " ;[CO] = '" & Me.[CO] & "' ;[COn] = " & Me.[COn] & " ;
---------------------------------------- break -----------------------------------------
[BL] = '" & Me.[BL] & "' ;[BLn] = " & Me.[BLn] & " ;[BO] = '" & Me.[BO] & "' ;[BOn] = " & Me.[BOn] & " ;
---------------------------------------- break -----------------------------------------
[AL] = '" & Me.[AL] & "' ;[ALn] = " & Me.[ALn] & " ;[AO] = '" & Me.[AO] & "' ;[AOn] = " & Me.[AOn] & " ;
---------------------------------------- break -----------------------------------------
[Length] = '" & Me.[Length] & "' ;[Lengthn] = " & Me.[Lengthn] & " ;[Mold] = " & Me.[Mold] & " ;
---------------------------------------- break -----------------------------------------
[Plate] = '" & Me.[Plate] & "' ;[PlateSize] = " & Me.[PlateSize] & " ;[Type] = '" & Me.[Type] & "' ;[Location] = '" & Me.[Location] & "' ;
---------------------------------------- break -----------------------------------------
[0] = '" & Me.[0] & "' ;[00] = '" & Me.[00] & "' ;[1] = '" & Me.[1] & "' ;[2] = '" & Me.[2] & "' ;[3] = '" & Me.[3] & "' ;[4] = '" & Me.[4] & "' ;
---------------------------------------- break -----------------------------------------
[5] = '" & Me.[5] & "' ;[6] = '" & Me.[6] & "' ;[7] = '" & Me.[7] & "' ;[8] = '" & Me.[8] & "' ;[9] = '" & Me.[9] & "' ;[10] = '" & Me.[10] & "' ;[11] = '" & Me.[11] & "' ;[12] = '" & Me.[12] & "' ;
---------------------------------------- break -----------------------------------------
WHERE [Mold#] = " & [Mold#] & " "
Willie
SQL$ = "UPDATE MoldList SET Rework = IIF(Me.Scrapped=-1,DATE(),"") ; Notes = IIF(Me.Scrapped=-1,Me.Reason,"") ; [LastRepair] = '" & Me.[LastRepair] & "' ;
[DL] = '" & Me.[DL] & "' ;[DLn] = " & Me.[DLn] & " ;[DO] = '" & Me.[DO] & "' ;[DOn] = " & Me.[DOn] & " ;
---------------------------------------- break -----------------------------------------
[CL] = '" & Me.[CL] & "' ;[CLn] = " & Me.[CLn] & " ;[CO] = '" & Me.[CO] & "' ;[COn] = " & Me.[COn] & " ;
---------------------------------------- break -----------------------------------------
[BL] = '" & Me.[BL] & "' ;[BLn] = " & Me.[BLn] & " ;[BO] = '" & Me.[BO] & "' ;[BOn] = " & Me.[BOn] & " ;
---------------------------------------- break -----------------------------------------
[AL] = '" & Me.[AL] & "' ;[ALn] = " & Me.[ALn] & " ;[AO] = '" & Me.[AO] & "' ;[AOn] = " & Me.[AOn] & " ;
---------------------------------------- break -----------------------------------------
[Length] = '" & Me.[Length] & "' ;[Lengthn] = " & Me.[Lengthn] & " ;[Mold] = " & Me.[Mold] & " ;
---------------------------------------- break -----------------------------------------
[Plate] = '" & Me.[Plate] & "' ;[PlateSize] = " & Me.[PlateSize] & " ;[Type] = '" & Me.[Type] & "' ;[Location] = '" & Me.[Location] & "' ;
---------------------------------------- break -----------------------------------------
[0] = '" & Me.[0] & "' ;[00] = '" & Me.[00] & "' ;[1] = '" & Me.[1] & "' ;[2] = '" & Me.[2] & "' ;[3] = '" & Me.[3] & "' ;[4] = '" & Me.[4] & "' ;
---------------------------------------- break -----------------------------------------
[5] = '" & Me.[5] & "' ;[6] = '" & Me.[6] & "' ;[7] = '" & Me.[7] & "' ;[8] = '" & Me.[8] & "' ;[9] = '" & Me.[9] & "' ;[10] = '" & Me.[10] & "' ;[11] = '" & Me.[11] & "' ;[12] = '" & Me.[12] & "' ;
---------------------------------------- break -----------------------------------------
WHERE [Mold#] = " & [Mold#] & " "
Willie