After Insert Macro Event

Office 2013 and later

Office 2010

Last modified: July 28, 2015

Applies to: Access 2013 | Office 2013

The After Insert event occurs after a record is added.

Note
The After Insert event is available only in Data Macros.

Remarks

Use the After Insert event to perform any actions that you want to occur when a record is added to a table. Common uses for the After Insert include enforcing business rules, workflows, updating an aggregate total, and sending notifications.

You can use the Updated("Field Name") function to determine whether a field has changed. The following code example shows how to use an If statement to determine determine whether the PaidInFull field has been changed.

 
If  Updated("PaidInFull")   Then 
 
    /* Perform actions based on changes to the field.   */ 
 
End If

The following table lists macro commands that can be used in theAfter Insert event.

Command Type	Command
Program Flow	Comment Macro Statement
Program Flow	Group Macro Statement
Program Flow	If...Then...Else Macro Block
Data Block	CreateRecord Macro Action
Data Block	EditRecord Macro Action
Data Block	ForEachRecord Macro Action
Data Block	LookupRecord Data Block
Data Action	CancelRecordChange Macro Action
Data Action	ClearMacroError Macro Action
Data Action	DeleteRecord Macro Action
Data Action	ExitForEachRecord Macro Action
Data Action	LogEvent Macro Action
Data Action	OnError Macro Action
Data Action	RaiseError Macro Action
Data Action	RunDataMacro Macro Action
Data Action	SendEmail Macro Action
Data Action	SetField Macro Action
Data Action	SetLocalVar Macro Action
Data Action	StopAllMacros Macro Action
Data Action	StopMacro Macro Action

To create a Data macro that captures the After Insert event, use the following steps.

Open the table for which you want to capture the After Insert event.
On the Table tab, in the After Events group, click After Insert.

An empty data macro is displayed in the macro designer.

Example

The following code example uses the After Insert event to perform some processing when a record is added to the Donations table. When a record is added, the amount of the donation is added to the DonationsReceived field in the Campaigns table and the TotalDonatedField in the Donors table.

Click here to view a copy of the macro that you can paste into Macro Designer.

To view this example in the macro designer, use the following steps:

Open the table for which you want to capture the After Insert event.
On the Table tab, in the After Events group, click After Insert.
Select the code in the following code example and then press CTRL+C to copy it to the Clipboard.
Activate the macro designer window and then press CTRL+V.

<DataMacros> 
  <DataMacro Event="AfterInsert"> 
    <Statements> 
      <Comment>This data macro increments the DonationsReceived field in Campaigns and theAmountCollected field in Pledges </Comment> 
      <Action Name="SetLocalVar"> 
        <Argument Name="Name">varAmount</Argument> 
        <Argument Name="Value">[Amount]</Argument> 
      </Action> 
      <ConditionalBlock> 
        <If> 
          <Condition>Not (IsNull([CampaignID]))</Condition> 
          <Statements> 
            <ForEachRecord> 
              <Data> 
                <Reference>Campaigns</Reference> 
                <WhereCondition>[ID]=[Donations].[CampaignID]</WhereCondition> 
              </Data> 
              <Statements> 
                <EditRecord> 
                  <Data /> 
                  <Statements> 
                    <Action Name="SetField"> 
                      <Argument Name="Field">[DonationsReceived]</Argument> 
                      <Argument Name="Value">[DonationsReceived]+[varAmount]</Argument> 
                    </Action> 
                  </Statements> 
                </EditRecord> 
              </Statements> 
            </ForEachRecord> 
          </Statements> 
        </If> 
      </ConditionalBlock> 
      <ConditionalBlock> 
        <If> 
          <Condition>Not (IsNull([DonorID]))</Condition> 
          <Statements> 
            <ForEachRecord> 
              <Data> 
                <Reference>Donors</Reference> 
                <WhereCondition>[ID]=[Donations].[DonorID]</WhereCondition> 
              </Data> 
              <Statements> 
                <EditRecord> 
                  <Data /> 
                  <Statements> 
                    <Action Name="SetField"> 
                      <Argument Name="Field">[TotalDonated]</Argument> 
                      <Argument Name="Value">[TotalDonated]+[varAmount]</Argument> 
                    </Action> 
                  </Statements> 
                </EditRecord> 
              </Statements> 
            </ForEachRecord> 
          </Statements> 
        </If> 
      </ConditionalBlock> 
    </Statements> 
  </DataMacro> 
</DataMacros>
 
SetLocalVar 
              Name   varAmount 
        Expression   =[Amount] 
 
If   Not (IsNull([CampaignID]))   Then 
 
     For Each Record In   Campaigns 
        Where Condition   =[ID]=[Donations].[CampaignID] 
                  Alias 
 
             EditRecord 
                          Alias 
                 SetField 
                             Name   [DonationsReceived] 
                            Value   =[DonationsReceived]+[varAmount] 
            End EditRecord 
End If 
 
If   Not (IsNull([DonorID]))   Then 
 
     For Each Record In  Donors 
        WhereCondition   =[ID]=[Donations].[DonorID] 
                 Alias 
 
             EditRecord 
                          Alias 
                 SetField 
                             Name   [TotalDonated] 
                            Value   =[TotalDonated]+[varAmount] 
             End EditRecord 
End If