#Name? error on a form

[JonathanT]

I want to thank everyone who posted suggestions for my issues.

Unfortunately nothing has worked. The error persists. I ended up creating my calulations on a table and using that to show on my form.

[Welshgasman]

Well, we have established that there is nothing wrong with the calculation as 3 people here have it working without any issues?
So the problem is at your end which we cannot see.

Did you try a simple form with just those field and that control, purely as a test?

[JonathanT]

I did not. I will try that when I revisit this problem in the future. Thanks for you help

[June7]

Do you have another computer you can test on?

I seem to recall a situation at work where one computer had issue with db. Finally replaced that computer.

[JonathanT]

I tried it on my laptop, opened and closed the DB a few times. Restarted my laptop, Move the file from one folder to another on my laptop. The calculation worked as designed. Just opened/closed the file on my main PC (mutiple times) and the error is not showing. Strangest thing I have ever seen

[Welshgasman]

Strangest thing I have ever seen

Me too, that I have heard. Always worth asking others to check something out.