#name error

[fire2ice]

I am baffled. My report has some unbound textboxes that perform calculations based on other fields in the report ( e.g. =[CountOfUniqueStates]+[SumOfCountNoState]+ SumOfCountNonUS] ). When the report loads I get the #name error. All three of these fields are on the report so it's not a question of control source. However, if I add any control onto the report and view it, the #name error magically disappears. Unfortunately, if I close the database and later reopen the report, the #name error returns. This is reproducable.

Oh, to make things more complicated, the page numbering in the footer has the same problem. This is a built in function and it is producing the #name error. It just doesn't make any sense.

Thanks in advance for any help you can provide.

 

[rainman89]

put the fields on the report, and then set their visible property to no

 

[fire2ice]

put the fields on the report, and then set their visible property to no

The fields are on the report. Even if that were the problem, it wouldn't explain the page number issue or why it calculates properly when I add a new control to the report. I can add any control without even setting a source for the control and it fixes the problem until I restart Access.

Thanks.

 

[rainman89]

have you tried creating a new report and copying the format over from the old one?

 

[fire2ice]

It must be magic. As inexplicably as the problem occurred, it has vanished. Hopefully the glitch won't return. The odd thing is that the issue was reproducable on different days with two different computers. Darn those gremlins!!!

If this rears its ugly head again, I will post back.

Thanks.