Trigger event by writing value to a field

[Bieke]

Hello,

When i manualy change the value of a field in a form then the event 'afterupdate' of that field will be triggered.
What i want to do is write a value to that field using vba (so not by typing in to the field)
When the value changes by writing to that field then i want to run a function.
How do i do it ....?

Thanks in advance,

Bieke

 

[Gasman]

Call it?

 

[Bieke]

Call it?

How do i call it?
There must be an event triggered when the value changes in the controlfield, then i can execute a function in this event but how do i trigger it?

 

[Gasman]

Crossposted https://www.accessforums.net/showthread.php?t=90120

 

[GPGeorge]

You might be able to implement this with a Data Macro on the table.

Data Macros run regardless of where or how a value is changed in a field.

 

[ebs17]

What i want to do is write a value to that field using vba

If you use VBA in such a targeted manner, you can also call the desired function. You don't need an extra event for this.
However, you would have to check separately before calling the function whether the content of the control really changes when it is overwritten using VBA. This raises the question of what exactly this VBA write action looks like in order to make a modification.

run a function

Of course, one could also take a closer look at what exactly this function is supposed to do.

 

[CJ_London]

Already suggested in the crosspost