Hi,
I was trying to have a variable as a control name
I have seen lots refer to
Dim ControlXYZ as control
I get a compile error on this line, a module is not a valid type
No matter what name I use, so I know not it is not duplicated anywhere.
Sure my references are OK, never had problem with anything else.
Below does work and seems petty but I like to know why something does not work as others seem to have. Office 365
ControlXYX = "ThisControl"
frm.Controls(ControlXYZ) OK
I also think neater frm.ControlXYZ
Thanks I/A
I was trying to have a variable as a control name
I have seen lots refer to
Dim ControlXYZ as control
I get a compile error on this line, a module is not a valid type
No matter what name I use, so I know not it is not duplicated anywhere.
Sure my references are OK, never had problem with anything else.
Below does work and seems petty but I like to know why something does not work as others seem to have. Office 365
ControlXYX = "ThisControl"
frm.Controls(ControlXYZ) OK
I also think neater frm.ControlXYZ
Thanks I/A