Solved Where Is Syntax Error In My Code - Run-time Error 3075

[ysdai]

With the O/P having over 800 posts, you'd hope they knew that by now?

I never checked that part. Sorry about that.

 

[Gasman]

I never checked that part. Sorry about that.

YOU do not have over 800 posts

 

[Ashfaque]

remove the Last ")" and replace it with just " " (space).

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.