Does anyone know what causes this error and what it means??
Thanks in advance. I'm pretty new at this!
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]