Refreshing/Requery bounded textboxes

[jasonbarnes]

I have a bunch of textboxes that are on a form. The form is bound to one table. This textboxes show metrics which are products of the table. Things such as Counts of certain fields etc.



One textbox does a sum of one field. However for some reason this textbox gets hung up with old data and replicates the previous sum then sums them together. So if I had 100000 one time then opened it again it would be 200000. My control source is set to Sum([SumofTEUS]). And I can easily verify that the table itself is staying the same and what the number should be.

Other parts of the data are manipulated on this form with action queries. All the corresponding boxes to these work fine. I refresh the textboxes to show the updated numbers by doing a requery to refresh the form. What should I do/try???

[ajetrumpet]

I don't understand this, James.

You have a box with a sum in it? and it IS changing or it's NOT changing? and what's the event that's happening that's causing this unwanted behavior from the box? I didn't get that either.

[jasonbarnes]

I completely import new data to analyze at different intervals.

First time around they all work flawlessly.
If I open this form again.. the sum is doubled... but the counts still work fine.

Therefore I'm not that sure what causes the unwanted behavior. Its almost like the Sum([fieldname]) is caching the old sum then doubling it. But if the form is bound to the same test table, and the control source is simply =SUM([fieldname]) what would cause this.

[ajetrumpet]

You didn't answer my question at all, James.

So let me see...you import data into the same table that you had it before and you're REPLACING the old data with the new? through the import wizard? Is the form open while you're doing this? If it is, it shouldn't be.

it doesn't sound like anything is corrupted. it sounds like the methods are just a little bit off, and the program doesn't like it!

[jasonbarnes]

No the form is not open when I do the import.

Yes - it is completely replacing the old data with new.

I'll have to play with it some more and see if I can pin down the problem.