[AccessD] Passing Param arrays

Hi John

I think you need to pass the ParamArray on ByRef as a Variant
(containing the array). 
Or retrieve the single elements of the array and pass these on as
single parameters to the next ParamArray.

As I read it, what you do now is to pass the array as one element of a
new array.

/gustav

>>> jwcolby at colbyconsulting.com 24-12-2004 05:05:08 >>>
I have a function which has a ParamArray FieldNames()

This function calls another function with the same ParamArray
FieldNames()

The first function attempts to call the second function, passing the
paramarray Fieldnames on to the second function.

In debug mode I can step through the ParamArray(0), etc and see that
there
is indeed data in the param array.
The 2nd function receives the paramarray, but it is empty.

Does anyone know if it is possible to pass a paramarray back out to a
second
function?

John W. Colby
www.ColbyConsulting.com