#Name?

[Bobbi]

HI...I am having a problem with a report that I'm creating. In one of the fields I am getting the error "#Name?". I have checked the ControlSource property, which is ok. I have checked the spelling, which is ok. At first they had the same name for 3 separate queries which is where I'm wanting to get my data. I have since corrected it on the tables and the queries, but still can not figure why in the heck I keep getting that error. The only thing I want the control box to give me is the amount from the "Sum of..." box in a query. No fancy schmancy totals...just carry over the amount.

Please, Please, I beg of you to help me out!

Thanks
Bobbi

 

[Karl K]

Do you by chance, have the same name for the textbox as one of the fields in the box?

 

[Bobbi]

Karl, that might have been the problem. I found another way to make it work. I used "DLookup" at the query and just took the total.

I will go check and see if that was the possible problem though and keep that in mind in the future.


Thank you very much!
Bobbi