>I don't think you need the 'dimension This.aList(alen(This.aList, 1))', the SQL to array works the way you originally thought.

That was the line that made it all work. If you issue a Select OneField ... Into Array MyArray, the Array is dimensioned as [1, Length]. So I had to redimension the array so it would be like [Length]. e.g.,

aList[1], aList[2], instead of aList[1,1], aList[1,2]. The array rowsource fails if the array is not 1 dimensional.