Calling a function on a subform from another form

[Guest]

Can someone please tell me the syntax for calling a function in a subform's
code from the close event of another form? What I have (that doesn't work)
is this:

Call [Forms].[frmMainFormName].sbfSubFormName.FunctionName

Thanks in advance,

 

[Guest]

put the function in a standard module and make it
Public Function ...

Now you can call it from anywhere within your application

 

[Marshall Barton]

Can someone please tell me the syntax for calling a function in a subform's
code from the close event of another form? What I have (that doesn't work)
is this:

Call [Forms].[frmMainFormName].sbfSubFormName.FunctionName

As long as the otther form is still open, this will do that:

Forms![frmMainFormName].sbfSubFormCONTROLName.FORM.FunctionName

But what about the function's arguments and/or return value?
Or are you calling a Sub procedure?