How to create an After Update macro in FE. Tables are linked. BE is different.

[jdraw]

Sach,
I don't think yo can interrupt/breakpoint a macro.
The point of the afterUpdate data macro on tblSummary is to ensure changes are written to tblLog regardless of from where the changes to tblSummmary arise(query/form/vba/direct table interaction).
F8 and breakpoints work with vba only (as I understand things)

 

[SachAccess]

Hi @jdraw thanks a lot for the help.
Please correct me if am wrong.

Audit_FE this file has VBA modules.
Thought I can see and edit the code manually, since it is called by Access Macro, I will not be able to interrupt it.
Even if it a VBA code, can be interrupted when called by Access Macro.

Have a nice day ahead.

 

[GPGeorge]

Hi,

I tried searching various website for the solution. I was not able to find it.
Am I correct in thinking that I cannot write After Update macro in BE based on the changes done in FE.

I am trying to create a log for the changes done in tables.
Changes would be done from FE.
Tables are linked from BE.
How do I solve this problem.
Can anyone please help me understand this.

After Update Macros are in the tables in the database where those tables are located. Pat already explained that. Jack explained that.

They run when data is changed in the table to which they are attached, regardless of how that change occurred. Period. Any change to data in a table with an After Update macro on it, when initiated via the Front End does, of course, invoke that macro as soon as the change is saved to the table. That can be done with an update query, with VBA running that modifies the records in that table, or a form bound to that linked table. It can even be invoked by opening the table directly in Datasheet view and manually changing data.

The advantage of that, of course, is that the user simply cannot bypass the data macro. It is integral to that table and does not depend on the method used to modify the data.

I don't see any reason to try to manipulate that from the FE. That's not why we use Data Macros like After Update. They can't call VBA in the Front End.

 

[SachAccess]

Hi @GPGeorge thanks a lot for the help. I agree @Pat Hartman has helped me in this.
However, there was some confusion from my side.

Have a nice day ahead.