jwcolby
jwcolby at colbyconsulting.com
Fri May 16 11:41:37 CDT 2008
Drew,
That is not happening here. I place a debug.Print in the init event of
the class and it fires exactly once. In fact I can close and reopen the
test form and it does not fire again (as it should not).
This code in the main function:
'
'checks if the class is initialized
If mclsCallback Is Nothing Then
Set mclsCallback = New clsCallBack
If mdb Is Nothing Then
Set mdb = CurrentDb
End If
End If
checks if the mclsCallback is initialized and does not initialize it again.
John W. Colby
www.ColbyConsulting.com
Drew Wutka wrote:
> Do you realize that you are creating an instance of this class for each
> callback?
>
> No wonder it's sluggish! (To check, but a debug statement into your
> initialize event).
>
> Drew