Calculated control on a form isn't calculating

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
M

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
 
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.
 
[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).
 
And of course you could write your subtraction expression as a calculated
field in the query and just refer to that field.
 
Back
Top