First time trying to do this, works correctly within the function but when passed upward to the calling procedure, not so much.
Function itself is declared as a Variant
Within the function, I Dim intCounts(3) as a Variant, scroll through a recordset and increment the three elements of the array; end result is three integers stored in the array, e.g., 0, 201, 51
Return value of function is then set to intCounts(3)
But back at the calling procedure,
intEndCounts(3) has been declared as a Variant, but
setting intEndCounts(3) = the function's return value gives me 0, 0, 0
Obviously I'm missing something despite considerable Googling. Any help out there? If this general description isn't adequate I'll post a bare-bones version of the actual code.