Assign value to variable on other form

[tylerg11]

I have set a "form-wide" variable on a certain form to contain integers. I want to populate this variable from a subform located on this form.

So, for example, if the form has an integer for CompanyID, I want to populate this variable from the subform so that when I am back on the main form I can use this variable with the populated variable. What is the syntax for this?

[John_G]

Hi -

The syntax differs depending on where you have the code, the main form or the subform.

You can use something like this, from the main form:

Me![controlname1]= me![subformcontrolname].form.[controlname2]

where:

[controlname1] is the name of the main form control to receive the value
[subformcontrolname] is the name of the control containing the subform
[controlname2] is the name of the control on the subform containing the value you want.

Note that you do not use the actual name of the subform!

From within the subform, the syntax is:

Me.parent![controlname1] = me![controlname2], with the meanings the same.

Which of the two you use will depend on what you need to do.

HTH

John

[tylerg11]

Yes, I'm able to reference controls on the main form from a subform just fine. But what I am trying to do is reference not a control, but a string variable that is declared at the form level.

[John_G]

Hi -

I have not tried this (reference a variable in a subform), but I have referenced a variable in a main form. I can't guarantee it will work, but try this:

Declare the variable in the subform as Public (in the declarations section) : Public variablename as String

Then, reference it from the main form as : me!subformcontrolname.form.variablename

HTH

John