UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Skip after update event    
 
   
MrSiezen
post Aug 30 2005, 02:53 AM
Post #1

UtterAccess Ruler
Posts: 2,196
From: Den Bosch - Netherlands
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?
Go to the top of the page
 
+
jimdunn
post Aug 30 2005, 04:14 AM
Post #2

UtterAccess Addict
Posts: 131
From: Australia
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.
Go to the top of the page
 
+
MrSiezen
post Aug 30 2005, 04:46 AM
Post #3

UtterAccess Ruler
Posts: 2,196
From: Den Bosch - Netherlands
Gah, how simple can it be sometimes...

Thx
Go to the top of the page
 
+
jimdunn
post Aug 30 2005, 05:01 AM
Post #4

UtterAccess Addict
Posts: 131
From: Australia
No problem

Jim
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 03:21 PM