Calculated control #Name? error

[Jenno]

I have simple form with a control source of a data table. On the form
I have a number of text boxes with calcuated controls for example:

Name: txtTotalFTE
Format: Fixed
Control Source=[DirExLaborNbr]+[DirTempLaborNbr]+[IndSanNbr]+
[IndFLTNbr]+[IndLeadNbr]+[IndQANbr]

This works fine, correctly showing the total.

In another text box I have the following but the result is #Name?:

Name: txtTotalHrs
Format: Fixed
Control Source=[txtTotalFTE]*8

I have several other text boxes where I need to reference other
calculated controls (with much more complex calculations than this
one) but I always get the error. The text box names do not appear in
the forms control source.
What am I missing here?

Thanks.

 

[Allen Browne]

Check the Name property of the problem text box. It must not be the same as
the name of a field in the form's RecordSource. For example, it must not be
called DirExLaborNbr.

If you have several calculated controls on a form, the problem may be in one
of the others. Once Access finds it cannot resolve a calculated control, it
gives up trying on the others. You may therefore need to eliminate some
calculated controls until you pin down the culprit.

 

[Jenno]

Allen

Many thanks for guidance. The Name was not an issue, I deleted all
the text boxes with the calculations and recreated them in a different
sequence and it worked fine.

What sequence does Access work through these, in the created order or
reading order?

Mike.

 

[Allen Browne]

It's not simple to identify the calculation order Access uses for calculated
controls, as there can be all sorts of dependencies (even circular ones.)

Perhaps there was an error in the content or name of one of the controls. Or
perhaps something like a Name AutoCorrect error was causing Access to
identify the wrong things and make it uncalculatable. Who knows.