Global Array

[kdbailey]

I am looking at making somewhat of a "global array", if you would. To compare what I am trying to do to something in much simpler terms... consider shuffling a deck of cards. You shuffle it once, and come back to it multiple times. I can randomize the array to a final output, but how do I make it global, so it doesn't disappear after the code is complete and I can retrieve the randomized array at later times. I also am not looking to write it to a table or something of that sort.

[kdbailey]

Dismiss this, the very next idea I tried ended up working.

[June7]

Declare the array in a general module. Then any procedure can reference it. Be aware that global variables lose their value if code execution is interrupted by error and then terminated.

[orange]

I would suggest saving that array as a table of values. That is how you preserve the data from one access session to another. What is your rationale for not using a table? Then again, you can always create a randomized array-why would you need to keep it from session to session?

[kdbailey]

The mistake I was making was declaring a global array with a defined number of elements, and then defining those elements as a constant, before rearranging them.

I.E.

Global array1(5) As Variant, array2(5) As Variant

Function test()
array1()  = Array("1", "2", "3", "4", "5", "6")

'Code to randomize and place into array2

End Function

That was my mistake. I have my desired results, no need to look further into this.

Thanks though guys.