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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BeforeUpdate Cancel 0
Afterupdate event 6
BeforeUpdate or AfterUpdate ? 11
BeforeUpdate and KeyDown 2
Skip MsgBox in BeforeUpdate if Save Button Click = True 5
Update Events in Split Database? 6
How do I trim an input field 9
Which Form Event should I use? 3

Back
Top