Solved Where Is Syntax Error In My Code - Run-time Error 3075 (1 Viewer)

Ashfaque

Student
Local time
Tomorrow, 04:51
Joined
Sep 6, 2004
Messages
894
remove the Last ")" and replace it with just " " (space).
Code:
strSQL = "UPDATE T_JobOffer " & _
"SET [CECompany]= '" & Forms!F_SaudizationPercent!CECompany & "', [CACompany]='" & Forms!F_SaudizationPercent!CACompany & "', [CCrNumber]='" & Forms!F_SaudizationPercent!CCrNumber & "' " & _
"Where (T_JobOffer.CNO)= " & Forms!F_SaudizationPercent!CNo
Thanks Arnel. It is working now.
 

Users who are viewing this thread

Top Bottom