setting variables 1

[primerov]

Setting variables


In my modules made public, i have several functions where i must set the variables each time
for each function.
For example :



Set chickens = [Forms]![Farm]![Subform].[Form].[Quantity]
Set poultry = [Forms]![Farm]![Subform].[Form].[cartons]
Set customer = main![Customerid]
etc
etc



Since i have more variables to set, i would like to ask is there any way
to put these setting in the general section of the code and to be made public to
all the functions in the database?

 

[glalsop]

If you HAVE too, you could declare them as public in a general module, then set their values in the after update event of the text boxes.

So create module PublicVars, and declare:

Public numChickens As Long
Public numPoultry As Long

Then, in the after update event of any text boxes that you need to change the value:

numChickens = Me.Quantity

or

numChickens = numChickens + Me.Quantity



-Gary

 

[willir]

primerov

If you HAVE too

Using a lot of global variables may be a tad dangerous. I do not know the reasoning or your design, but if you have to reference values in a form perhaps you may consider an alternate approach. Perhaps a multitab form with the "global" settings in the header of the form. Each tab and each subform can reference the variable in the header part of the form.

Richard