Calculation of amount boxes

[visidro]

I am farily new to access need help with a calculation please



We have a form where we enter various amounts and a box where these are added together to calculate taxes.
This amount is shown on the screen but we need to save this total amount in the table where it can be used in other calculations in other forms

the control in the box looks like this: =[registration fee]+[membership fee]+[fee per term]+[additional classes fee]+[costume]+[books]-[discount]+[applicable gst]+[uniform fee]

How can I get the result of this formula saved in another table field?

thank you
victor

[June7]

Usually a bad idea to save calculated result. The calculation can be done whenever needed.

However, to do so will required VBA code. The real trick is figuring out what event. Perhaps in the form BeforeUpdate simply:

Me!fieldname = Me.textboxname

Could any of those fields be Null? If so, need to handle Null because calculation with Null will result in Null. Try:

Nz([additional classes fee],0)

[visidro]

all the fields have a $0 as their default value.

I have added an Event Procedure for the "Before Update" on the form with this:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!totalamount = Me.amount
End Sub


Nothing is hapening ... not sure I understand the "Me"

[June7]

Me is alias for the object (form or report) that the code is behind. It is shorthand for Forms!formname.

The BeforeUpdate event won't trigger unless something in the record is entered/edited.

[visidro]

Excellent!!

Thank you; again!
victor