Referencing control by value in field

[JRT]

Happy Holidays to everyone,

I'm trying to reference a control so I can change the position of it. I need to step through a table and grab the control name from a field in the table/form.

For example TableA has 3 fields [Fieldname],

, [Top]

On a different form I'll have OLE objects that have all of their names listed in Table A. As you step through Table A, change the location of the OLE object based on the values in Left and Top.

I know how to do this in a static environment, but I can't reference the new control name when I step to the next record.

Clear as mud?

Thanks for any ideas.

Dave​

 

[boblarson]

If you want to select a variable control name, you can use:


Me.Controls(YourControlNameAsStringHere).YourPropertyHere

 

[JRT]

Thank you very much sir.

Have a great holiday season.

Dave