Mutliple Event Sink problem

[Michael Cleroux]

Hi there,

I read this in the Access 2002 help file:

'The class that raises an event is the event source, and the classes that
implement the event are the sinks. An event source can have multiple sinks
for the events it generates. When the class raises the event, that event is
fired on every class that has elected to sink events for that instance of
the object.'

So I want one form to raise an event, and a second form to respond to the
event. This says I should be able to do it, but I can't seem to make it
work. I can get the form which raises the event to respond, but not the
second one.

What I've got so far is this, so where do I go from here to get other forms
to respond to the same event?

Thanks a lot in advance ... Mike

In a class called TestEvent
Public Event RefreshDetail()

Public Sub Refresh()
RaiseEvent RefreshDetail
End Sub

In Form1:
Public WithEvents Testing As TestEvent

Private Sub Form_Load()
Set Testing = New TestEvent
End Sub

Private Sub EvDetail_DblCli ck(Cancel As Integer)
Testing.Refresh
End Sub

Sub Testing_Refresh Detail()
MsgBox "test from list"
End Sub