Trigger event by changing field programmaticly

[Anna987]

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 change the value of that field by writing a value to it programmaticly (so not by typing in to the field)
When the value changes then i want to run a function.
How do i to this ....?

Thanks in advance,



Bieke

[CJ_London]

If by ‘writing to it’ you mean using vba then extend the vba to compare the existing value with the new value the vba is providing

something like

if newvalue<>controlname then
  controlname=newvalue
  call function 
End if

[Minty]

The other option is a data macro, which acts at a table level, depending on what's required.

[Anna987]

If by ‘writing to it’ you mean using vba then extend the vba to compare the existing value with the new value the vba is providing

something like

if newvalue<>controlname then
  controlname=newvalue
  call function 
End if

WIth writing to it i mean by using a button write a value to the field ([field] = 5)
How can i execute the function if newvalue <>controlename .......

[Anna987]

WIth writing to it i mean by using a button write a value to the field ([field] = 5)
How can i execute the function if newvalue <>controlename .......

[ano]

question : what / why is there a difference between type into the field and use button to put value into the field?
my logic would be : in on_change event from the field put the function you want to use if there is a change in the field.
if it realy only need to run from the button , put cj_london's code into the on_click from the button

[CJ_London]

not sure how simpler it can be

if 5<>controlname then
  controlname=5
  call function 
End if

Be clear about whether you are talking about controls on a form or fields in the form recordset.

[Anna987]

The difference is that the event will not be executed when you write a value to a controlfield, only if you TYPE it in the field the event AfterUpdate will be executed.

[Welshgasman]

Crossposted 16 minutes ago https://www.access-programmers.co.uk...-field.332115/

[Anna987]

I'm sorry. Is it not allowed to post on different forums? I try to find as many ideas ...

[Welshgasman]

I'm sorry. Is it not allowed to post on different forums? I try to find as many ideas ...

No per se, but considered good manners to inform users of the fact, as advice can get repeated and people are wasting their time repeating what has already been offerred, as has happened in this case with regard to data macro.
You have been here since 2015 and 2017 on that other forum, so should be aware in all that time.
Just inform people when you do so please.

[CJ_London]

The difference is that the event will not be executed when you write a value to a controlfield, only if you TYPE it in the field the event AfterUpdate will be executed.

I am well aware of that - the code I provided would be put in your button click event since this is what you appear to be using per post#4

[Anna987]

I am well aware of that - the code I provided would be put in your button click event since this is what you appear to be using per post#4

Hello CJ,

i understand that it is a little confusing how i try to make myself clear.
I mensioned the button to explain my problem the easy way but this is my explanation of the exact problem.
In fact there are 2 databases wich share some tables with a BE database.
From a form of database1 i want to start a function in database2. What i'm trying to do is set a value in a BE table. This value i use in a control in database2.
When the value changes in database2 i want to trigger an event that execute that function. But when the value changes there is no event like AfterUpdate of this control that will be called.
I taught that maby there is a possibility when the control that is written with a value from database 1 some event can be triggered?
Probebly there is a more simple solution for this problem but this is how i want to fix this.

Thanks for your help so far.

Regards.

[Anna987]

Hello Minty,

I'm not familiar with data macro. I find something on Youtube.
I'll try it.

Thanks.

[CJ_London]

This value i use in a control in database2.

for this to work, you (not another user) would have the have database2 open from within database1(and to be clear - you mean a front end, not a database which is the back end) and the relevant form open as well to be able to reference the control.

All depends what your function is supposed to do but perhaps a data macro is the way to go....