[AccessD] Function Return array?

Hi Sander:

Can you not just pass the array, by name through the function call? I have
not done so, with an array but have been passing types/collections/objects
for years and can see no reason why an array is different. Why not send the
whole Listbox?

Private Function MyFunction(MyComboBox As Control, typHardlyMyType as
MyType) As Control
 ...

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D
Sent: Friday, February 06, 2004 1:20 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Function Return array?


Andy,

I don't get it.
I can indeed create an array, then call the function using the array as a
paramater and then what? I need the values from the array.

Correct if I'm wrong but I still need to return the values from the function
to my event (form OnLoad) How do I do that?

I want to achieve the following:
1 - Fill an array with items in the specified listbox.
2 - loop through the array and when the current value of the array matches
with the current item in the listbox...select the item in the listbox.

Hope this makes sence

Regards,

Sander


Andy Lacey <andy at minstersystems.co.uk> wrote:
Create the array outside the function, pass it in as a parmeter and have the
function fill it?

Andy Lacey
http://www.minstersystems.co.uk

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of S D
> Sent: 06 February 2004 08:04
> To: accessd
> Subject: [AccessD] Function Return array?
>
>
> Hi group,
>
> I have a function that builds an array. Is it possible to
> let the function return the array?
>
> Any ideas?
>
> TIA
> Sander
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website:
> http://www.databaseadvisors.com
>
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com