Call proceedure in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franky - 14 Sep 2005 18:04 GMT

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

Thanks in advance!

Reply to this Message

franky - 14 Sep 2005 19:05 GMT

I figured it out. Hopefully this is the correct way to do it.

Dim frm as form

Set frm = Forms!myForm
frm.ProceedureName

Thanks

> How do i call (reference) a public proceedure in a form from another form?
>
> Thanks in advance!

Reply to this Message

David C. Holley - 14 Sep 2005 19:47 GMT

Actually that's not neccessary you can do it with

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

> I figured it out. Hopefully this is the correct way to do it.
>
[quoted text clipped - 8 lines]
>>
>>Thanks in advance!

Reply to this Message

Marshall Barton - 14 Sep 2005 19:31 GMT

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

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message