Compile Error: Expected: ( in Update statment

[EddyLLC]

Using the following Update statement I get a "Compile Error: Expected: (" with the last appersand in the last line highlighted (the one directly after "strComp". I thought I've tried every variation with no luck. The string value strComp may contain hyphens. Can anybody see what I did wrong? Thanks.

strSQL = "Update Renewal"
strSQL = strSQL & " SET Renewal.SalesLastYr = " & lngSalesLastYr & ", " _
& "Renewal.LTM = " & lngLTM & ", Renewal.RenewalNotes = '" & mmoNotes & "'"
strSQL = strSQL & " WHERE Renewal.Comp = '" & strComp & "'

 

[EddyLLC]

I just discovered strComp is the name of a function so I changed the variable name and it works fine so... never mind.

 

[strongm]

strComp is a VB function. That's what is causing your problem

 

[Andrzejek]

Also, watch for any single quotes in [tt]mmoNotes [/tt] and in whatever you used for [tt]strComp[/tt]
If you allow to have them, they will couse a problem in your strSQL

Have fun.

---- Andy