<div>
Would this be how to set the form level variable? &nbsp;I am also wondering whether this is necessary. &nbsp;I run a query that updates records that have afterupdate events I don't want to run after.<br />
<br />
<br />
Private Sub Bypass()<br />
Dim BypassAU As Variant ' variable to bypass After Upate events<br />
BypassAU = True<br />
End Sub<br />
<br />
then in the afterupdate events:<br />
<br />
If BypassAU = True Then <br />
BypassAU = False<br />
<br />
Exit Sub<br />
<br />
Else
</div>


Would this be how to set the form level variable?  I am also wondering whether this is necessary.  I run a query that updates records that have afterupdate events I don't want to run after.


Private Sub Bypass()
Dim BypassAU As Variant ' variable to bypass After Upate events
BypassAU = True
End Sub

then in the afterupdate events:

If BypassAU = True Then
BypassAU = False

Exit Sub

Else

<div>
Are you talking about a data macro which fires when you update a record in your table, or preventing the AfterUpdate event of a form from firing?<br />
<br />
What version of Access?
</div>


Are you talking about a data macro which fires when you update a record in your table, or preventing the AfterUpdate event of a form from firing?

What version of Access?

<div>
preventing a After Update event from firing.
</div>


preventing a After Update event from firing.

<div>
2016.<br />
<br />
I am initially running a query that updates fields. &nbsp;These fields also have AfterUpdate events that I want to bypass after the initial query is run.
</div>


2016.

I am initially running a query that updates fields.  These fields also have AfterUpdate events that I want to bypass after the initial query is run.

<div>
<div class="content wysiwyg-content">
When I run a certain query, I want Access to skip the after update events on a sub form. &nbsp;Is this possible?
</div>
</div>


When I run a certain query, I want Access to skip the after update events on a sub form.  Is this possible?

Omit After Update event

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.