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

[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

 

[Dirk Goldgar]

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?

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

 

[Paul]

Works great.

Thanks, Dirk.

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)