auto populate

[jc]

I have 3 field on a form, 2 of which I enter a value in. I
want the third to auto calculate the sum of the first two
field. However if i change the contol source on the form
to a calculation it will not show in the that third field
when i display the table. Any suggestion?

 

[Ed Robichaud]

JC -
If I understand you correctly, you're trying to save a calculated form
control value to a table field. This is generally not a good idea. Your
forms and reports can calculate that value any time you need to display it,
and you won't have to worry about keeping a static value current.

-Ed