Best way to return array from function

[pullingteeth]

Say I have the function in a module:

private function getWords() as Variant
	dim words as String(10)
	...
	getWords = words
end function

Now say that I need to use the array in a ListResults function in a form; how would you best accomplish this?

I can't assign the getWords results to an array variable (array assignation not allowed, at least in Access 97), so therefore I need to convert it somehow, so that I can store it as a global variable:

words = TheModule.getWords
for each word in words
    ' build my global array incrementally
next word

This is obviously inefficient, though. Isn't there some way to cast, or directly convert, the results?

Thanks

 

[SkipVought]

Hi,

words = TheModule.getWords
for i = 0 to ubound(words, 1)
  x = words(i)
    ' build my global array incrementally
next

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}