How to pass a value to a form, store it in a variable and use in all Sub of the form

[MiniG]

I trying to pass a value from one form to another, store it in a variable and be able to use the variable in all of the Sub of the form.


I am calling my form using

DoCmd.OpenForm "ViewCompany", , , , , , Me!CompanyCombo.Value()

In Form_ViewCompany, I am retrieving this value in Private Sub Form_Load():

CompanyID = CInt(Me.OpenArgs)

Now this works if I declare CompanyID as a global variable in a module

Public CompanyID As Integer

I want to avoid using global variables as it might create problems and conflicts later in my form workflow.

If I declare CompanyID in Private Sub Form_Load(), I cannot use this value in other Private Sub associated with the form, for example, with an On_Click() event.

I would like to know how to declare a variable (and set its value) that can be used in all Sub associated with a form, but cannot be accessed from other forms. I believe this is a "scope" problem and I am trying to figure out the best way to do it. Some people online are suggesting storing the passed value in a hidden Text Box on the form and use its .Value in the other Sub, but I am sure there must be a better way to do this.

Thanks

[ranman256]

just put it in a text box,...

docmd.openform "frm1"
forms!frm1!txtBox = forms!frmMyForm!txtBox2

or

forms!frm1!txtBox = 12

then everything in the form can see the textbox.

[kd2017]

There's also TempVars.

[accesstos]

Add a read-only property to the form.


Now, for the outer procedures, you have a read-only member of the form ("Company") that refers to the private variable "mCompanyID" and only the owner's procedures can change it's value, as seems above in Form_Load() event.

[Micron]

IIRC, if the variable is placed in the Declarations section of the form module it is a form level variable that is available to all procedures behind the form. It cannot be accessed by other modules, regardless of whether or not you declare it Public or Private. That seems to be what you're asking about re scope. If you create a variable in a standard module, you can restrict its scope to the module (Private) or make it available to the whole project (Public).