Question about VBA Code

[stevo_3]

Hello,

I am currently debugging the code of a collegue and I am having the following error:
"Runtime error '3705':
Extra ) in query expression "')'

This error message comes when executing the following code:
strSQL = "UPDATE KBArticles SET UID='" & strUID & "' ,Naam='" & HandleQuotes(strNaam) & "', Omschrijving='" & HandleQuotes(strOmschrijving) & "' ,Company=" & bolCompany & " ,Location=" & bolLocation & ",IVR='" & strIVR & "') WHERE UID='" & strUID & "'"

DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
-------------------------------------------------------------------------------------------

Somewhere a bracket is missing in the strSQL could anybody tell me where I have searched too long

Greetings
S.

 

[Mile-O]

Before the WHERE you have a random bracket. Take it out.

 

[stevo_3]

Yes this was it,

many thx for your support!!