The code that falls to the second line is red, and of course, that's where the code fails (that's what I mean by "it doesn't like it"). Even breaking the code with a " _" makes the subsequent lines red.
Here is my code ...
strSQL = "INSERT INTO RepairInfo(FirstName,LastName,StudentID,StudentSite,School,PrevTicketNum,AssetNumber,Ass,SvcTag,Svc,EquipDesc,DamageDesc,PrevBackFromDD,NotesDowntown,NotesDesktopDr,PrevDDWO,Drop,Spill,OtherType,LCD,LCDOther,Palmrest,Palm-Repair,Bezel,Keyboard,BottomPlas,Btm-Repair,TopPlas,Top-Repair,Harddrive,Webcam,Battery,Hinges,Screws,OtherDamage) VALUES(" & "'" & Text4 & "'," & "'" & Text12 & "'," & "'" & Text6 & "'," & "'" & Text83 & "'," & "'" & Text83 & "'," & "'" & Text1 & "'," & "'" & Text8 & "'," & "'" & Text8 & "'," & "'" & Text14 & "'," & "'" & Text14 & "'," & "'" & Text68 & "'," & "'" & Text55 & "'," & "'" & Text80 & "'," & "'" & Text71 & "'," & "'" & Text73 & "'," & "'" & DDWO & "'," & "'" & Check43 & "'," & "'" & Check45 & "'," & "'" & Check47 & "'," & "'" & Check19 & "'," & "'" & Check201 & "'," & "'" & Check21 & "'," & "'" & Check23 & "'," & "'" & Check25 & "'," & "'" & Check27 & "'," & "'" & Check29 & "'," & "'" & Check31 & "'," & "'" & Check33 & "'," & "'" & Check35 & "'," & "'" & Check37 & "'," & "'" & Check39 & "'," & "'" & Check41 & "');"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
Dim TicketMax As Long
TicketMax = DMax("[TicketNum]", "RepairInfo", "[AssetNumber] = Text8")
DoCmd.OpenForm "frm_RepairTicket", , , "TicketNum = " & TicketMax
DoCmd.Close acForm, "frm_RepairInfo"