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]
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.