#Name? Error on Form

Hi,

I have a form that has fields referencing calucations from
a query. All my references are fine, except for one - I
have tried everything, but I keep getting the #Name?
error. According to the Help file, it can be that my
calculation is not written properly (It is, I copied it
from another reference that works); it can be circular
(not possible); the name of the field could be misspelt
(again, copied it from another reference that works); or
it could be that the reference has been removed (which it
hasn't - it shows up under the fields list).
Any suggestions??? I am stuck here all alone at work on a
beautiful Toronto Saturday, and I'm going stir crazy - any
suggestions would make me really, really happy!
Thanks a lot to all,
Chris

.....Never mind - I'm obviously going crazier than I
thought - I forgot to close and reopen the form.....it
works beautifully now....
-----Original Message-----
Hi,

I have a form that has fields referencing calucations
from
a query. All my references are fine, except for one - I
have tried everything, but I keep getting the #Name?
error. According to the Help file, it can be that my
calculation is not written properly (It is, I copied it
from another reference that works); it can be circular
(not possible); the name of the field could be misspelt
(again, copied it from another reference that works); or
it could be that the reference has been removed (which it
hasn't - it shows up under the fields list).
Any suggestions??? I am stuck here all alone at work on
a
beautiful Toronto Saturday, and I'm going stir crazy -
any
suggestions would make me really, really happy!
Thanks a lot to all,
Chris
.