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