Jumping for BeforeUpdate to AfterUpdate

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
 
A

Allen Browne

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

Top