Call Function

[Steve]

What is the syntax to call Public Function MyFunction(parm1, parm2) in
MyForm's module from a function in a standard module?

Thanks,

Steve

[Terry Kreft]

You have to get an instance of the form loaded to do this.

Dim f As Form_MyForm
Dim parm1
Dim parm2

DoCmd.OpenForm ("MyForm")

Set f = Forms("MyForm")

Call f.MyFunction(parm1, parm2)

Set f = Nothing

DoCmd.Close acForm, "MyForm"
...

--
Terry Kreft
"Steve" <no****@nospam.spam> wrote in message
news:AL****************@newsread2.news.atl.earthli nk.net...

What is the syntax to call Public Function MyFunction(parm1, parm2) in
MyForm's module from a function in a standard module?

Thanks,

Steve

[Steve]

Terry,

Will this work?

MyForm is already open before the function in the standard module is run. So
just put this line of code in the function:
Call Forms!MyForm.MyFunction(parm1, parm2)

Thanks,
Steve

"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:Dw********************@karoo.co.uk...

You have to get an instance of the form loaded to do this.

Dim f As Form_MyForm
Dim parm1
Dim parm2

DoCmd.OpenForm ("MyForm")

Set f = Forms("MyForm")

Call f.MyFunction(parm1, parm2)

Set f = Nothing

DoCmd.Close acForm, "MyForm"
...

--
Terry Kreft
"Steve" <no****@nospam.spam> wrote in message
news:AL****************@newsread2.news.atl.earthli nk.net...

What is the syntax to call Public Function MyFunction(parm1, parm2) in
MyForm's module from a function in a standard module?

Thanks,

Steve