I'm still wrestling with arrays, and their still winning. Here's my problem as briefly as I can explain it.
Program objective: Clicking checkboxes, the user selects which NASDAQ Market makers (Goldman Sachs, Schwab, etc) the program will graph (x = time, y = price) on a MDI-child picture box.
To do this, I have created two arrays: the first array, arrCurrMMSelector as Integer, collects the number of each checkbox selected (7, 11, 33, 44, etc.). The array is defined in a .bas module.
The second array, arrMMdata, is a user-defined type. It is populated by running the Market makers identified in arrCurrMMSelector against a SQL7 database. arrMMdata has 16 elements and can hold upwards of 10,000 rows. This array is also defined in the same .bas module. So far so good.
My problem is, I need to nest arrMMdata in arrCurrMMSelector in the linedraw function so that it loops thru each market maker and draws the data points(x,y) in the MDI-child picture box.
If I try to do something like:
arrJoint(2) As Variant
arrJoint(1) = arrCurrMMSelector()
arrJoint(2) = arrMMdata()
in the General Declarations of MDI child or .bas, I get the error "Invalid outside procedure" highlighting arr(1) = arrCurrMMSelector(). But if I try the same thing in the function itself, I get the error "Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bounded functions" highlighting arr(2) = arrMMdata().
Does anybody have an idea how I should proceed or--judging by some of the responses to my last posting, do I have to move everything into a class to make this work? Thanks a lot.
