Forum Discussion

rhill1959's avatar
rhill1959
Copper Contributor
Apr 26, 2023

Dynamic reference to array

Hi, it's been a long time since I've done any VBA code within Access.  I have a situation where I globally defined 2 arrays. Dim a1() as string Dim a2() as string Within a Sub routine, I need to c...
access
App
rhill1959's avatar
rhill1959
Copper Contributor
Apr 26, 2023

Tom_van_Stiphout 

Thanks Tom,

I actually did that as a work around, but was hoping to figure out a way to reference the array name through a variable value.

Tom_van_Stiphout's avatar
Tom_van_Stiphout
Steel Contributor
Apr 26, 2023
Maybe you can pass the array to work on as an argument?

Resources