ms access - vba: Compile Error: expected: =


I have a subroutine as below

Public Sub updateStagesTable(sName As String, percentageValue As Double)
    stageName = "'" & sName & "'"
    sSQL = "INSERT INTO StagesT ([Stage Name], [Stage Value In Percentage]) VALUES (" & stageName & "," & percentageValue & ");"
    DoCmd.SetWarnings False
    DoCmd.RunSQL sSQL
End Sub

and I call it from another subroutine as below

economy = 3.53
updateStagesTable ("Economy", economy)

But I get this compile error

Compile Error: expected: =

I don't understand what I am doing wrong here. Please help.


Answers:


updateStagesTable ("Economy", economy)

should be

updateStagesTable "Economy", economy

with no parentheses

See related: Unexpected results from typename