how to subtract 2 fields in my form

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i have a form with 2 fields one called est value with an
amount say of $100,000 and another field called priority
liens with an amount of say $10,000 i enter both these
amounts in separate fields and then i want to tab to the
next field and have it subtract these two and put the
amount in this new field automatically is there a way
to do this?
 
Hi Dan

In an unbound Text Box simply set the Control Source as follows:
=[Est Value] - [Priority Liens]

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top