Referring to another form

[gmatriix]

Hello All,

What I need to do is change this statement

Screen.ActiveForm!RawData.Text = MyData

to

Screen.ActiveForm!RawData1.Text = MyData

based off some criteria ....I tried some concatenation but it cannot not recognize it now.

I was thinking...for example

Dim RD as string

RD = "RawData"


Screen.ActiveForm!RD &"1".Text = MyData ???

The reason im doing this is because the 1 will change to a 2 or 3 ect base off of some criteria

Any Ideas?

 

[pbaldy]

Shot in the dark, but try

Screen.ActiveForm(RD &"1") = MyData