Calculated Fields on Forms

  • Thread starter Thread starter Anne
  • Start date Start date
A

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.
 
Anne said:
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.
Click to expand...
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
 
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.
 
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??
Click to expand...

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.
 
Back
Top