Full Version: Skip after update event
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
MrSiezen
Hi!

A control has a After Update event which runs fine. But I don't want that event to happen if the control is applying to a new record (the event works with before update events, which don't excist yet).

Is there a way to block this event?
jimdunn
Wrap up your existing code in this IF statement


CODE
Private Sub YourControl_AfterUpdate()

If Not Me.NewRecord Then

    'Your event code here

End If

End Sub



Jim

Edited by: jimdunn on Tue Aug 30 5:19:18 EDT 2005.
MrSiezen
Gah, how simple can it be sometimes...

Thx
jimdunn
No problem

Jim
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.