The problem with calculated text boxes

Hi guys,

I have a calculated text box that uses 2 other text boxes to make a
calculation. I have the form set to appear as a continuous form.

The problem that I have is that when I enter the textbox, the calculation is
done as it should be, but then the value of all the textbox of all the
records changes to the result.

Is there any way around this except to actually store the result in the
table?

Thanks guys.

Kenny