Execute Form Module Code Extrernally

  • Thread starter Thread starter Mike Lempel
  • Start date Start date
M

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
 
Mike Lempel said:
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
Click to expand...

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
 
Back
Top