running a Sub in a class module from a functionin a general module

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

If I have a sub in the module for a form named frmActivity which contains a
procedure named

Sub cmd_close_form_Click()

is there a way to call that Sub and run the procedure from a function in a
general module?

Thanks in advance,

Paul
 
Paul said:
If I have a sub in the module for a form named frmActivity which contains
a procedure named

Sub cmd_close_form_Click()

is there a way to call that Sub and run the procedure from a function in a
general module?
Click to expand...


Only if:

(a) the form is open, and
(b) the declaration of the Sub is changed to:

Public Sub cmd_close_form_Click()

If those two criteria are met, then you can call the Sub via a reference to
the form:

Call Forms!frmActivity.cmd_close_form_Click
 
Works great.

Thanks, Dirk.


Dirk Goldgar said:
Only if:

(a) the form is open, and
(b) the declaration of the Sub is changed to:

Public Sub cmd_close_form_Click()

If those two criteria are met, then you can call the Sub via a reference
to the form:

Call Forms!frmActivity.cmd_close_form_Click


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...
 
Back
Top