#name?

[KindleFire]

I have a few rpts that work fine, then on this one I keep getting #name? errors. I have 5 subrpts I am running out of options? Any help

 

[Sara Overton]

It's probably that you have a field in the report which does not appear in your query behind it.

 

[KindleFire]

I checked that it is a valid field, any other suggestions

 

[rpadams]

I've had this happen when I replaced the controlsource of a bound field with an expression. For example, in the bound textbook [LastName] I typed "=[LastName]&"' "&[FirstName]" and then reference the [LastName] textbox on the report. Got the #Name error. You need to create an UNBOUND textbox for the expression.