#NAME?

Here are some reasons…

1. Make sure that the field specified in the control’s ControlSource property hasn’t been removed from the underlying table or record source.
2. Check the spelling of the field name in the control’s ControlSource property.
3. If you specified an expression in the control’s ControlSource property, make sure that there is an equal sign preceding the expression.
4. Make sure the names of the field does not match the name of any of the controls in your formula
5. Check for missing references