I have an unbound text box and none of the event functions are working 1

[GICodeWarrior]

The box has "=Sum([Amount])" in the control source box. This way it adds up the Ammounts. The problem is that I want to run a macro when this field updates. I have tried everything but the field won't do anything when particular events are triggered.
Please help,
Code Warrior Burchfield

I write code. See code run. Run code run.

 

[GICodeWarrior]

I read up and I do not think that the value in the unbound box with the "=Sum([Amount])" control source changing triggers the after update event.

Is there any other way to run a macro when that field changes?

I tried putting the macro in the after update of the Amount field but the value of the unbound box hasn't changed by then(it takes a split second longer) and I need it in the macro.

Please help, Code Warrior Burchfield

I write code. See code run. Run code run.

 

[Aivars]

Hi!

Apparently you have bound text box (control source "=Sum([Amount])" ). In such case you can't update this text box - it updates automaticaly. If you want to update text box you must empty control source property on properties window. So text box will become unbound.

Aivars