passing variables between several forms?

[Jerome]

(using Access 2003)

Hi,

How can I use, or access, variables on several forms?
I'll explain:
Form A has two buttons b1 and b2.
Both buttons open the same form B.
But I want form B to behave slightly different whether it's opened by b1
or b2.
How can I now send a value through the Click event of the button and get
it through the Load event of the second form?

I tried several things but they didn't work out.

Thanks a lot!

Jerome

 

[Rick Brandt]

(using Access 2003)

Hi,

How can I use, or access, variables on several forms?
I'll explain:
Form A has two buttons b1 and b2.
Both buttons open the same form B.
But I want form B to behave slightly different whether it's opened by
b1 or b2.
How can I now send a value through the Click event of the button and
get it through the Load event of the second form?

I tried several things but they didn't work out.

Thanks a lot!

Jerome

The easiest is to use the optional OpenArgs argument for the OpenForm method.
The form thus opened can then refer to its own OpenArgs property to retrieve
that value.

 

[Guest]

docmd.OpenForm "aaaa",,,WhereCondition,,,OpenArgs
Use the openArgs To pass parameters,

docmd.OpenForm "aaaa",,,WhereCondition,,,"View"
On the on load property of the second form add the condition
If you have fiew parameters you want to pass
Select Case OpenArgs
case "View"

End Select
For One parameter
If OpenArgs="View" then
endif