Access will display a #Name error whenever it cannot find a field with
a field name entered into an expression.
It may mean the field does not exist or you have simply miss-spelled
the field name, i.e. a control source of:
=[Amonnt] * [Cost]
will display  #Name because the field named [Amount] was miss-spelled
and Access can't find a field named [Amonnt]