CODEWITHSUNDEEP
ms-accessms-access-data-macro
Santosh
Santosh

Reputation: 12353

After Insert data macro not running

I have a table tblEmp with a After Insert data macro defined. However, the event is not working. what I am missing here?

enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 3021

Answers (1)

Parfait
Parfait

Reputation: 107577

Simply move your logic to the BeforeChange trigger which is the state before any record (new or existing) is saved. Your logic attempts to change field values in AfterInsert which is after the save mode. Also, be sure to not include the table identifier, tblEmp, in referencing column name in macro:

Data Macro Design View

In fact, had you clicked the Application Errors on status bar in lower right after your current attempt, the outputted system table indicates the issue since you are in read-only mode after inserting:

EditRecord failed because the default alias represents a record which is read only.

Upvotes: 2

Related Questions