Updating textbox value in form footer

[LonghronJ]

OK, I'm stumped. I basically have a textbox, call it txtNewValue in the form footer that I would like updating after the user updates a bound textbox in the detail section and after the user clicks a save button . I have straightforward math for txtNewValue calculation, but now since it's not updating correctly, I've assigned values to TempVar variable and made txtNewValue bound to the TempVar variable. I noticed that in real time, the txtNewValue is not updating when the user clicks the save button. However, when I step through the codes, upon the me.form.requery, the value is updated. If I remove the break point and run it, txtNewValue does not get updated. Even if close down the form and relaunch it, txtNewValue is not updated. What's going on?

[June7]

What is this value in txtNewValue? Is it a Sum of records in the subform? Should not be saving this calculated aggregate to table.

What is purpose of showing this aggregate on form? This is normally best done in report.

[LonghronJ]

What is this value in txtNewValue? Is it a Sum of records in the subform? Should not be saving this calculated aggregate to table.

What is purpose of showing this aggregate on form? This is normally best done in report.

No, txtNewValue is actually the difference between a variable and the sum of the detail. I just don't understand that when I step through the VBA code in the various routines involved, I can see the textbox value change, but when I remove the breakpoint, nothing happens.

[isladogs]

Try adding the line DoEvents in your code to allow processing to complete.
Do you need to requery the control as well?

[LonghronJ]

Try adding the line DoEvents in your code to allow processing to complete.
Do you need to requery the control as well?

What do you mean by DoEvents, like DoCmd.RunCommand acCmdSaveRecord ?
And yes, I have requery the form and the textbox as well, but still no luck.

[isladogs]

Just write DoEvents on it's own line as one word with no space.

[LonghronJ]

Nice, DoEvents seems to do the trick. I've never used this function before. Not sure what this is, but I'm going to read up on it. Thanks, Colin.

[isladogs]

As I said before, it allows processing to complete before going on to the next line of code