Execute Form Module Code Extrernally

[Mike Lempel]

I have 2 forms, FormA and FormB. There is code associated with the Current
Event of FormA. FormB is opened from FormA, and FormA remains open. When
FormB closes (FormA still open) I would like the Current Event Sub of FormA
to execute. Is this possible, and if so, what is the proper VBA statement?
I'm using Access97.

Thanks very much for any help.
Mike

 

[Dirk Goldgar]

I have 2 forms, FormA and FormB. There is code associated with the
Current Event of FormA. FormB is opened from FormA, and FormA
remains open. When FormB closes (FormA still open) I would like the
Current Event Sub of FormA to execute. Is this possible, and if so,
what is the proper VBA statement? I'm using Access97.

Thanks very much for any help.
Mike

It is only possible to call that event procedure directly if you change
its declaration from

Private Sub Form_Current()

to

Public Sub Form_Current()

Then you can write (from FormB's Close event):

Forms!FormA.Form_Current