Calculated control on a form isn't calculating

[Max Yaffe]

I've got a form with a calculated text field that displays the text
"#Name?" when I show the form.

What's really confusing is that the expression is defined. For
example if I put in "TotalList", where TotalList is a field in the
query that underlies the form, the correct value is displayed.
Howeverif I put in "=[TotalList]", I get "#Name?" displayed.

I'd actually like to display the expression "=[TotalList]-[Discount]"
where both terms are fields in the query.

I've used this syntax before and it's in the manual. What am I doing
wrong?

Thanks in advance,
Max

 

[Ken Snell [MVP]]

Chances are strong that you have a control on the form that is named
TotalList, and that control is not bound to the field named TotalList. Thus,
ACCESS doesn't know whether to use the control or the field for the value in
your expression. Change the name of that "TotalList" control to something
else...such as txtTotalList.

 

[Bob Howard]

[TotalList] is probably not unique! To make it unique, specify
[xx...xx]![TotalList] where [xx...xx] is the name of the entity owning the
particular [TotalList] that you're after (probably the query).

 

[Tom Ross]

And of course you could write your subtraction expression as a calculated
field in the query and just refer to that field.