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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula in Form Not updating Table 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Crazy Query needs help 1
query on linked tables 1
Calculated Field 3
Calculation 1
Unbound text box calculation 6
Clear contents of an unbound text box on a bound form. 2

Back
Top