#Name? error in Access form

[Yeprem]

Hello,

Hoping someone can help with my problem.

I have built a small database with 2 tables and 1 form. In the form, I am trying to concatenate 2 fields from the table which are also in the form. One of the fields is not visible in the form since I do not want anyone messing around with it.

When I concatenate the 2 fields by inputing =[Field1] & [Field2] in the Control source for the text box, the text appears fine until I close the database and re-open it. Once I re-open the DB, the filed displays #Name?.

I have checked the forms Record source and it is correct.
I have checked if the fileds show up in the existing fields window and they do.
I have double, triple-checked the field names in the control source and they are ok also.
I tried using =[TableName]![Field1] & [TableName]![Field2] also but that doesn't seem to make a difference either. Every time I re-open the DB, the error comes up.

Access Help is not helpful and Google returns junk when I include #Name? in the search. It just ignores the # and ? marks.

Does anyone have anything else I can try. If you need more info, I will provide anything you need.

Thanks in advance for any and all assistance.

 

[Yeprem]

Got it to work. The problem was I was renaming the unbound text field I was adding. It was messing up data linking somewhere.

The issue is resolved.