Ref. to a variable in another form?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,

I woke up this morning to an Access snag! I hope someone
can help!

I have formA which contains subformformB in it. In the
VBA code, behind formA I declare a variable in the top
part of the page called x as bool. This variable gets set
and unset by the private procedures in formA.

But, sometimes I would like to read variable x but from
the VBA code thats behind subformB. How do I reference x
from subFormB when x is declared in code behind FormA.

Thanking you all in advance!

Bob
 
Bob said:
I have formA which contains subformformB in it. In the
VBA code, behind formA I declare a variable in the top
part of the page called x as bool. This variable gets set
and unset by the private procedures in formA.

But, sometimes I would like to read variable x but from
the VBA code thats behind subformB. How do I reference x
from subFormB when x is declared in code behind FormA.
Click to expand...


First, the variable must be declared Public (in the
declaration section of formA's module) so it can be accessed
from outside formA's module.

Since a form's module is a class module, whenever the form
is open, the variable is a property of formA's class so it
can be accessed the same way any property can be referenced.
From a subform in FormA it would just be:

Parent.x

From another form or a standard module, you need to use the
full form reference:

Forms!FormA.x
 
Back
Top