This article explains the reason why you might encounter the “#Name?” text when trying to reference a Field in one of the textboxes in an Access Form using the Expression Builder:

Reason #1:

Attempting to reference the field using its full name will result in this error:

The expressions below will all result in an the #Name? error:

[Table1]![Field1]


=[Table1]![Field1]


[Table1].[Field1]


=[Table1].[Field1]


Reason #2:

Attempting to reference fields from another table. A form can only connect to one Access table or query. A form cannot get its data from multiple tables. A workaround would be to create a query with  fields from different tables and bind the form to the query.

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

See also:

• Access Form, Fields From Multiple Tables
• Access Using Expressions (Calculated Fields) In Form Controls