#Name? Error Referencing Fields Access Forms, Expression Builder
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.
- Access Form, Fields From Multiple Tables
- Access Using Expressions (Calculated Fields) In Form Controls