Calculations in forms

[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

 

[Nikos Yannacopoulos]

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)