#Name? error in unbound, calculated text field

Hi everyone,



I've tried to understand and fix this error for a while now, and while it seems I'm not the only one to have run into it, I couldn't find any solution online.



What I have is:

A form containing a subform (continuous). The subform's Record Source is a query. The subform contains a bunch of text fields, taking their value from fields from the query.

Now, the fields that use the query's field as their Control Source directly have no issue; the values get display correctly.

But the fields that use a calculated value do not. Instead, I get a "#Name?" error on them.

I've checked, my controls don't have the same name as the fields from the query. Funny thing is, I have another form which contains exactly the same thing (different subform and source query of course, but the structure is the same), and the calculated values work perfectly.

I'd like to be able to have things like:

Code:

---

=Format([DatePlannedDelivery],"d/mm/yyyy (ddd)")

---

to get "10/03/2015 (Tue)" in my field.

But even if I just put "=[DatePlannedDelivery]" as the Control Source, it doesn't work.:confused:



What am I doing wrong?



Thanks in advance for your help!



[EDIT]

I forgot: I did use the Expression Builder to create the expressions, and the fields from the query are properly listed. I also tried the fully qualified names for the field (e.g. "[q_TaskList]![DatePlannedDelivery]) but that did not work either.

#Name? error in unbound, calculated text field