how to subtract 2 fields in my form

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?
 
S

StCyrM

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.
 

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

Top