Calculated field has me perplexed

[Jagged]

Hi


This little problem has me confused...

My form has a number of text-boxes setup to input amounts (7 in total). In addition I have a combo-box which allows the user to select a percentage, ie. 1%, 2% etc.

What I want to have happen is a calculated field that sums the 7 amount fields and multiplies it with the percentage selected. Should be relatively simple right? guess not.

What I have done is write a formula that looks like this:

=([FIELD1]+[FIELD2]+...+[FIELD7])*[PERCENTAGE]

It sorta works, but not really they way I want it to. When I enter amounts in the fields and selected the percentage the field is filled in. However, if I close the form and reopen then the amount is displayed. If you change any of the amounts or the percentage another close + reopen is required to calculate.

How can I make the field calculate instantly?

 

[pr2-eugin]

Okay before providing the solution is this (calculated) Field stored in the table?

 

[Galaxiom]

Try Me.Recalculate in the AfterUpdate Event Procedure of the combo.

 

[Jagged]

No.

Only the 7 amount fields are stored.

 

[pr2-eugin]

Okay then follow Galaxiom's suggestion. Use the AfterUpdate event of the ComboBox..

 

[Jagged]

Perfect, thanks to both of you.

 

[pr2-eugin]

Glad we could be of some help. Good luck !