#Name? error

[Hans]

I am getting a #Name? error while trying to get a simple expression to work
in a subform. I used the Expression Builder to make it.

The expression takes a number from the primary form; a number from within
the subform is subtracted from it and the value is displayed in a field in
the subform:

=[Structures]![StructElevAtRimNAVD88]-[MeasureDown]

where "Structures" is the main form, "StructElevAtRimNAVD88" is a field in
Structures, and "MeasureDown" is a field in the subform.

One website indicated that I need ".Form!" like this:

=[Structures].Form![StructElevAtRimNAVD88]-[MeasureDown]

....but this does nothing.

Thank you,

-Hans

 

[Hans]

Never mind -- I figured it out. In the Expression Builder, you have to use
the Forms items, not their respective Tables.

 

[pedroka]

I am getting a #Name? error while trying to get a simple expression to work
in a subform. I used the Expression Builder to make it.

The expression takes a number from the primary form; a number from within
the subform is subtracted from it and the value is displayed in a field in
the subform:

=[Structures]![StructElevAtRimNAVD88]-[MeasureDown]

where "Structures" is the main form, "StructElevAtRimNAVD88" is a field in
Structures, and "MeasureDown" is a field in the subform.

One website indicated that I need ".Form!" like this:

=[Structures].Form![StructElevAtRimNAVD88]-[MeasureDown]

...but this does nothing.

Thank you,

-Hans