Hello all,
I am trying to do something that should be straightforward.
What I want to do is pass an array (2 dimensional) from form #1 to form #2
(byref) so the array is available to all subs and functions on form #2
letting any changes made to the array in form #2.
The problem is I have not been able to create a true form reference. I
have had to cheat by either assigning the array from form#1 to a form level
variant in form#2, then looping through my variant when done to assign
variables back to the original. OR Creating public subs on form#2 and
form#1, so that if a button is pressed on form#2, it runs a sub on form#1,
which calls form#2 sub with the array as an arguement.
Why is this so difficult? I would think that if I could pass an array to
one sub on another form where in that sub changes made to the array byref
to the original ---- Why can't I keep that reference for ALL subs and
functions?
Help!