#Name? Error Referencing Fields Access Forms, Expression Builder

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:
Error


Reason #1:

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

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:

Leave a Reply

Your email address will not be published. Required fields are marked *

privacy policy