How to refer to a control through variable in a report in VBA? 1

[inso18]

Hi Everyone.

I'm having trouble in trying to refer to a control in a Report through a variable

So far I have attempted this:

(i = VBA variable, txb1, txb2 ... are report's controls)

Me("txb"& i).Caption = "1"
Reports!MyReport("txb"& i).ControlSource = "field" & i
Reports!MyReport!Report("txb"& i).Visible = False

None of these works.
Any ideas on how to do it correctly?

Much thanks, inso

 

[MajP]

me.controls("txb"& i).Caption = "1

 

[inso18]

Thanks, that works
in forms me.controls( isn't necessary though, me( is enough I'm not mistaken