I had this issue also! I was using =[LAST] + ", " + [FIRST] in my control and still no matter the combinations I had no avail to resolve the issue.
I would close my database and each time it opened it would still give me the #name? error. I was using a form with tabs and a continuous subform...