J
Janis
The help file is not very helpful explaining how to do this. I want some
code to happen IF a new record is created. I'm trying to write the event
module. I picked the beforeInsert event. I don't have a form only
datasheet. This event should trigger if the new record is clicked in
datasheet view. I'm not sure how to set up the event trigger? Where do I put
the afterInsert event?
MyClass module:
Option Explicit
public event Flag(byref booFlag as Boolean)
Public Sub getFlag( )
RaiseEvent Flag(boolean)
End Sub
Option Explicit
Dim WithEvents objOtherClass As MyClass
Sub LoadClass()
Set objOtherClass = New MyClass
End Sub
Sub objOtherClass_getFlag(by ref booFlag as boolean)
booFlag
End sub
MyClass.Flag
AfterInsert
thanks,
code to happen IF a new record is created. I'm trying to write the event
module. I picked the beforeInsert event. I don't have a form only
datasheet. This event should trigger if the new record is clicked in
datasheet view. I'm not sure how to set up the event trigger? Where do I put
the afterInsert event?
MyClass module:
Option Explicit
public event Flag(byref booFlag as Boolean)
Public Sub getFlag( )
RaiseEvent Flag(boolean)
End Sub
Option Explicit
Dim WithEvents objOtherClass As MyClass
Sub LoadClass()
Set objOtherClass = New MyClass
End Sub
Sub objOtherClass_getFlag(by ref booFlag as boolean)
booFlag
End sub
MyClass.Flag
AfterInsert
thanks,