Refresh the Calculated Value in the Footer of a Subform

[melbushman]

Hello!

I have an unbound text box with a calculated value in the footer of a subform. The subform is a continuous form. I would like the unbound text box to update its value when data is entered into the continuous form. The unbound text box's source is =Sum([HistoryCost]). How do I make the unbound text box, in the footer of the form, update when I enter new values into the body of the form?

Thank you for reading my post! Happy Friday!

Mel

 

[jdraw]

What have you tried, with what results?

Perhaps Requery the textbox in the AfterUpdate event on the mainform???

 

[boblarson]

It sounds like it should already update automatically based on what you have. The only issue is that it will only update when the record is saved and that will only happen if you

1. Move to a new record
or
2. Save the record

You could put this in the after update event of the HistoryCost text box:

If Me.Dirty Then Me.Dirty = False