Calculations in forms

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I have designed a form to input cash and check totals
from a register. The data storage table also contains a
column for the total of those to entries. I would like to
be able to input my cash and check totals and have them
automaticly and in the total cell. However, I have not
been able to achieve that yet. What I need to know is if
it is possible and and if so how. Any help on this would
be greatly appreciated. Lee
 
Lee,

What you want to do is not only possible, it's also quite
easy. Assuming the names of the respective controls on
your form are Cash, Check and Total:
Bind all three controls to the respective fields in your
table.
Make a simple macro to setvalue of Total to =[Cash]+
[Check], and put it in the After Update event (in
properties, tab event) of the two other controls.
This will do what you want.

Nikos Y. (nyannaco at in dot gr)
 
Back
Top