Pass Array to a Different Form 1

[UncleCake]

Hi,

I am opening one form from another form and passing properties using Get and Let statements, which works fine.

I need to pass an array that contains 100 stock locations from the one form to the other or some other way to pass 100 values to the form that was opened.

How and can I pass an array using Let statement in the new form or is there a better way?

 

[shakespeare5677]

Make the property accept a variant:
public property let MyArray(x as variant)

Then, in the property itself, check for the variant being an array. You can also use global variables that can be seen by all forms at all times by declaring the array in a module as public or global.

-Max

 

[UncleCake]

Thanks Max! It took me a while, but I figured it out.

-UncleCake