By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

Four Subform Calculating..Help me..

P: 1
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....
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Sep 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.