Calculated Fields on Forms

[Anne]

Using Access 2000. I have a form with fields that
calculate data entered. This works fine. Problem is when
I go to next record for customer, the calculated totals
carry to the next form. How do I prevent this from
happening??

All help greatly appreciated.

 

[Ronald W. Roberts]

Using Access 2000. I have a form with fields that
calculate data entered. This works fine. Problem is when
I go to next record for customer, the calculated totals
carry to the next form. How do I prevent this from
happening??

All help greatly appreciated.

Do the calculation in the AfterUpdate event of the controls used in the
calculation and in the OnCurrent event of the form. The OnCurrent event
will fire everytime you move to a different record.

Ron

 

[Anne]

Ron, thanks for your response. Being a newby, I'm still
having difficulty. The form has 8 calculated fields.
Currently I have the formula in the "Control Source". I
moved the formula to the AfterUpdate event and wrote a
macro to refresh data which I put in the OnCurrent event
of the form. The calculation still moves to the next
record! Any other ideas??
Thanks in advance for your help! I've spent all day on
this issue.

 

[John Vinson]

Using Access 2000. I have a form with fields that
calculate data entered. This works fine. Problem is when
I go to next record for customer, the calculated totals
carry to the next form. How do I prevent this from
happening??

The next *record* on the Form I assume? How are you calculating them?
If the Control Source of the textbox is something like

=[A] +

then it should reflect the values of A and B in the currently
displayed record.