Subform Calculations

Thanks for that and I undestand what you are saying.

Cel.

"ruralguy via AccessMonster.com" wrote:

It is a calculated value and therefore should not be in a table. There are
no triggers in Access so there is nothing in the table to keep that field
accurate.

cel504 wrote:
I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.
[quoted text clipped - 13 lines]

Any ideas, on if this is possible. Many thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1