In a form based on a query, I have an ID field showing that error. In the query, that field is correct. The query is based on 3 tables. The field is listed in the available fields list. It is listed as the record source.
Jeffrey Eckert 3 months ago
It's possible that you have the same ID field from two tables in one query. For example, you may have tblEmployee.EmployeeID and tblContacts.EmployeeID both in the query. If that were the case, you would need to either remove one of the ID fields, or if you need them both in there, select the correct one as the Control Source for the control.
Troy Phillips 3 months ago
There is only one field with that name. When I run the query it shows the correct data, but when the form is opened it the "#Name?" in the that field.
Scott Axton 3 months ago
That error, #Name? , usually means the filed doesn't exist in the underlying data set.
Two things to check: Check spelling in the field on the form. Make sure it's in the query you are using.
