AfterUpdate Not Firing

[jimmy1981]

Hi,
I imagine this is unbelievably simple but I just can't find a solution from searching dozens of posts.

I have a subform which has a textbox in the footer which calculates a total amount. On my main form I have a textbox with the control source set to the textbox on my subform.

What i want to do, is every time this textbox changes, to update another textbox with the same amount.

So Textboxtotal and TextboxCopy are the same all the time.

Can anyone help me how to do this?

I understand that the afterupdate event wont fire as it is not updates via keypress, but i'm stuck there.

 

[MStef]

Try via BEFORE UPDATE event.

 

[jimmy1981]

I have the Text29 control source as

=[RecipesSubform].[Form]![txttotalsub]

I then went in to my Text29 beforeupdate and put the following:

Text39 = Text29

(Text29 is my total textbox and Text39 is my empty textbox that I wish to show the same as Text39).

Nothing happens, it's as though the event is not firing, Isnt this because the Text29 control was never 'touched' by the 'user'?

 

[MStef]

FORM BEFORE UPDATE event

 

[jimmy1981]

still nothing happens.

 

[jimmy1981]

I imagine this is because the changes are happening in the subform and then just writing it to the unbound textbox

 

[vbaInet]

What i want to do, is every time this textbox changes, to update another textbox with the same amount.

I understand that the afterupdate event wont fire as it is not updates via keypress, but i'm stuck there.

If you want to update the textbox each time a key is pressed you use the Change event of the control.