>>I should probably re-iterate that S[] is NOT scoped to the procedure. The idea is to use "macro-substitution" to set the control source for one text box on the form depending on which row in the grid is active. The intent is to dynamically set the control source for the text box to S[1,20] if you're on row 1, or S[2,20] for row 2 etc.

>>This works fine in the case of S[CurrRow,18] (as you can see from the code) but blows up on the other. The only difference between S[n,18] and S[n,20] is that 18 is an edit box and 20 is a text box. I use similar code to set control sources in many other places and always works fine.

>>-Arne

>Try surrounding the array control source with another pair of quotes first. See if that fixes the problem. What is the point of switching the columns? Can you describe exactly what you are doing?
>Dan

Switching the columns? Not sure what you mean. As I said though, the idea is switching the control source depending on which ROW the user is on. The reason for this is simply conservation of screen real-estate. I just use one text box and one edit box as otherwise the grid would be FAR too wide. Admittedly, the user is forced to drill-down into a row to view the contents of these two boxes, but in this case it is not a big deal as the boxes' values are typically set once on setup and then forgotten.

-Arne