How to pass paramters to a Form Module please?

[cantene]

Dear Friends,
I have a child form call frmDocument

I instantiate a form from it using

Dim frmD as frmDocument
Set frmD = New frmDocument

frmD.Caption = "Workspace" & counter

frmD.thisVariable = MyParameter
frmD.show

But how come thisVariable is nothing when I debug.print it out in the Form_Load event of frmDocument.

How can I solve it?

Thanks

[Lethal]

There are a few ways: Declare a Global variable in a standard module (.bas). Declare a private variable in the form module where the variable you want to pass resides in. Or you can just pass it as an argument to a procedure or function in the destination form. You could also use a property Let statement.

[honeybee]

Originally posted by cantene
Dear Friends,
I have a child form call frmDocument

I instantiate a form from it using

Dim frmD as frmDocument
Set frmD = New frmDocument

frmD.Caption = "Workspace" & counter

frmD.thisVariable = MyParameter
frmD.show

But how come thisVariable is nothing when I debug.print it out in the Form_Load event of frmDocument.

How can I solve it?

Thanks

Don't know for sure, but try putting this debug.print in the Form_Activate event and see if it gives you the correct results.

.

[cantene]

Can the Let Property be called by other places outside the form module?

Thanks

[Lethal]

Sure...Just declare the Let Procedure as Public.

[cantene]

When I set frmD.Caption
the form form event is immediately triggerred so that the subsequent code face error due to not ready preparation of the database connection string.

Now I just solve it by setting a public variable in a BAS module to allow the Form Load event to read it
Very low-level solving dirty skill