This is one of these occasions where I just can't see the wood for the trees. I am attemting to convert client records from a waiting list onto a live list via a userform. The userform shows the user the client details before they press the command button. The following code should take that information and INSERT a record into tblClientList but I get error 3075 (missing operator). I have tried everything but just can't see the problem. (the immediate window looks okay to me) Any help would be appreciated.
Code:
SQL = "INSERT INTO tblClientList (ClientID,DateAdded,FirstName,LastName,Title,[Address Line 1],[Address Line 2],[Address Line 3],"
SQL = SQL & "[Post Code],[Telephone Home],[Telephone Mobile],Counsellor,FullName,ClientAvailable,emailAddress,WLID,ContactTelHome,ContactTelMob,Voicemail,MobileText,ContactEmail,NoContact,OKtoIDTM,CounsellorPref)"
SQL = SQL & "VALUES ('" & Forms!frmConvert!ClientID & "','" & Forms!frmConvert!TxtDateAdded & "',"
SQL = SQL & "'" & Forms!frmConvert!FirstName & "','" & Forms!frmConvert!LastName & "','" & Forms!frmConvert!Title2 & "',"
SQL = SQL & "'" & Forms!frmConvert!AddressLine1 & "','" & Forms!frmConvert!AddressLine2 & "','" & Forms!frmConvert!AddressLine3 & "',"
SQL = SQL & "'" & Forms!frmConvert!PostCode & "','" & Forms!frmConvert!HomePhone & "','" & Forms!frmConvert!MobilePhone & "',"
SQL = SQL & "'" & Forms!frmConvert!Counsellor & "','" & Forms!frmConvert!FullName & "','" & Forms!frmConvert!ClientAvailable & "',"
SQL = SQL & "'" & Forms!frmConvert!emailAddress & "','" & Forms!frmConvert!WLID2 & "','" & Forms!frmConvert!Check79 & "',"
SQL = SQL & "'" & Forms!frmConvert!Check81 & "','" & Forms!frmConvert!Check82 & "','" & Forms!frmConvert!Check83 & "',"
SQL = SQL & "'" & Forms!frmConvert!Check84 & "','" & Forms!frmConvert!Check85 & "','" & Forms!frmConvert!Check86 & "','" & Forms!frmConvert!Text90 & "');"
Debug.Print SQL
DoCmd.RunSQL SQL