Jumping for BeforeUpdate to AfterUpdate

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hello

How do jump from the BeforeUpdate event to the
AfterUpdate event in code. For example from the
BeforeUpdate of a field in a form

If such a thing happens then goto the AfterUpdate event

Thanks in advance

Matt
 
Access automatically fires the AfterUpdate event if the BeforeUpdate is not
cancelled. Just cancel BeforeUpdate if you want to prevent that progression.

Example:
Private Sub Text1_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Text1) Then
Cancel = True
MsgBox "You are not allowed to progress to the AfterUpdate
event."
End If
End Sub
 
Back
Top