Calculations in forms where sum will be placed in an unbound fiel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add some fields in my form. The sum will be placed in an unbound
field. When I do this I get a $NAME error. For example, I have

Amt1: from table1
Amt2: from table1
Result = Amt1 + Amt2 (Result is unbound)

Any ideas?

(Note: If I include Result as a bound field in table1, then it works)
 
Set these properties for the 3rd text box:
Control Source: =[Amt1] + [Amt2]
Format: Currency (or General Number if you prefer).
 
Back
Top