Call proceedure in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i call (reference) a public proceedure in a form from another form?

Thanks in advance!
 
I figured it out. Hopefully this is the correct way to do it.

Dim frm as form

Set frm = Forms!myForm
frm.ProceedureName

Thanks
 
franky said:
How do i call (reference) a public proceedure in a form from another form?
Click to expand...


A form's module is a Class Module and procedures in a class
module are methods of the class. From that generalization,
the syntax would be:

Function:
xx = Forms!otherform.procedurename(arglist)
Sub:
Call Forms!otherform.procedurename(arglist)
or
Forms!otherform.procedurename arglist

Note that otherform must be open before it becomes a member
of the Forms collection.

If otherform is not open, you can use the syntax
Form_otherform.procedurename, but that is not the same thing
in cases where the procedure relies on data within the form
or its module.
 
Actually that's not neccessary you can do it with

Call Form_subfrmCodedRemarks.setSQLStatement("Confirmation")
[form module name].[procudure name] (any required parameters)
 
Back
Top