Calculations across forms?

S

Seddon Acaster

I am working on an accounts databse.

One form called residents contains fields called accountnumber and
accountbalance. Another form called invoice contains fields called credit and
accountnumber.

When you enter a number in credit on the invoice form I want the
accountbalance on the residents form to decrease by this amount. The value in
the field accountnumber on both forms is the same.

How do I do this?
 
Top