I have in a module:
Code:
'variables to store current school information for clustering schools with other schools
Public tmpSchoolIDstore As Variant, tmpClusterIDstore As Variant, tmpStateIDstore As Variant, tmpAreaIDstore As Variant
'method to store the current school into the variables used on the cluster form
Public Sub storeVarsCluster(SchoolsID As Variant, ClusterID As Variant, StateID As Variant, AreaID As Variant)
Debug.Print "Test 1 " & SchoolsID
Debug.Print "Test 2 " & ClusterID
Debug.Print "Test 3 " & StateID
Debug.Print "Test 4 " & AreaID
tmpSchoolIDstore = SchoolsID
tmpClusterIDstore = ClusterID
tmpStateIDstore = StateID
tmpAreaIDstore = AreaID
Debug.Print "TEMPS: " & tmpSchoolIDstore & " " & tmpClusterIDstore & " " & tmpStateIDstore & " " & tmpAreaIDstore
End Sub
for some reason on a form if I do debug.print on one of the public variables - I get nothing
Inside the module sub procedure the debug.print works fine - outside it no longer stores the information
i.e.
Debug.Print "Test " & tmpSchoolIDstore