Force update of unbound calculated control

[LillMcGill]

I have a subform that records payments made. In the header of this subform is an unbound text box (txtSumOfPayments) with the control source =SUM([PaymentAmount]). Ideally, as soon as the data entry person exits the record, the new sum is displayed. Sometimes this happens, but most of the time, the user will have to click back into the saved record in order to cause a recalc. I have tried Refresh, Requery, Recalc, Repaint... on a variety of events. What am I missing? I have something very similar on another form and it works, and I have similar in other databases. Any ideas?

[Bob Fitz]

Perhaps:
Me.txtSumOfPayments.Requery
or
Me.txtSumOfPayments.Recalc
in the forms After Update event.

[LillMcGill]

Thank you, but no joy. Maybe it has to do with it being version 2010 and a subform on a subform. I don't know. I discovered that clicking anywhere with the mouse updates, but nothing with the keyboard does. So I added a tiny Refresh button.

[Missinglinq]

The fact that the Expression is being used in the Control Source means that nothing should need to be done, once the Record is saved. The 'sometimes it does, sometimes it doesn't' makes me wonder if the Unbound Textbox has become corrupted.

Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Comboboxes, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If not, you've only lost a minute or two!

Linq ;0)>

[LillMcGill]

Great idea. I had already tried it, and also deleting the PaymentAmount textbox, but I tried it again now anyway. Still no change. Thanks though.

[Missinglinq]

[PaymentAmount] isn't a calculated field, itself, is it?

Linq ;0)>

[LillMcGill]

Nope; PaymentAmount is a textbox bound to a currency field in a table.

[Missinglinq]

No more ideas, without actually laying my hands on the file! If you can save a copy in an earlier version file format (2007 would do, but 2003 would allow more people, including Bob, to open it) Zip it up and attach it to a post, I'd be happy to have a look at it and see if I can figure it out!

Linq ;0)>