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

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:





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 *