Four Subform Calculating..Help me..

[xwjcity]

Hi everyone:

I am new here and I got Calculation problem. thanks in advance..

I have four subforms which retrieve data from different four tables. I created a textbox to do a calculation with the data from four subforms. When I first select a Customer to display on the mainform, the subform's data that related to mainform is correct, but the calculation use Previous Loaded data rather than current data to calculate. And when I select this customer again, the calculation result was right.

Can someone help me....

[MMcCarthy]

Hi everyone:

I am new here and I got Calculation problem. thanks in advance..

I have four subforms which retrieve data from different four tables. I created a textbox to do a calculation with the data from four subforms. When I first select a Customer to display on the mainform, the subform's data that related to mainform is correct, but the calculation use Previous Loaded data rather than current data to calculate. And when I select this customer again, the calculation result was right.

Can someone help me....

Try something like this:

Assuming your calculation textbox is called txtCalc. In the Current event of the form put ...

Me.txtCalc.Requery

See if that solves your problem.