>>
>>PMFJI: My observed problems with _Tally have been related to the value not being reliable if multi-table selects are involved. -snip
>
>Thanks. In this case I'm only using one table so I should be safe.
>
>Releasing the array first was my first thought by then I loose the reference. Is there a better way to handle this maybe?
>
>I have a form method that replaces the existing array with new data. I then need to pass that to a method in a class on the form. I saw a post in the FAQ about using objects as parameters but didn't quite understand it. Should I look at doing it that way?

Hi Roi:

Well, Jim Booth responded to my answer and tells me that I should be able to count on _Tally -- so maybe that's best for you on that point. As far as releasing the array -- I thought the steps I proposed were 1-release, 2-re-dimension/initialize it again, 3-attempt to populate, then 4-test it... Jim also indicated that he thought there could be a problem with that approach, but hasn't yet responded to my request for more detail on what was incorrect in my approach -- so maybe wait for him on that one.

As for passing objects as parameters -- I'm the wrong guy for that one. If the object is in same form as the methods, you could just refer to its properties, like ThisForm.Object1.Value -- but for more complex situations, I'm peddling as fast as I can, but still out of my league... (how's that for a mixed metaphor?).

HTH

Rob