ms access - vba: Compile Error: expected: =

updateStagesTable ("Economy", economy)

should be

updateStagesTable "Economy", economy

with no parentheses

See related: Unexpected results from typename

I have never liked this peculiarity of VB so I always use the alternate CALL syntax, in your case this would be:

Call updateStagesTable("Economy", economy)

which does allow the parentheses that all other languages expect