Hello,
Im trying to refer to a control on a form partly using a variable.
I want the variable to contain the form name as per below:
Path = "[Forms]![frm_NCT_sub2]!"
Path [AT_txt1].BackColor = 16761281
So when put togather should end up as
[Forms]![frm_NCT_sub2]![AT_txt1].BackColor = 16761281
BUT I get a compile error (expected procedure not variable).
Is there any way to do this?
Thanks
Im trying to refer to a control on a form partly using a variable.
I want the variable to contain the form name as per below:
Path = "[Forms]![frm_NCT_sub2]!"
Path [AT_txt1].BackColor = 16761281
So when put togather should end up as
[Forms]![frm_NCT_sub2]![AT_txt1].BackColor = 16761281
BUT I get a compile error (expected procedure not variable).
Is there any way to do this?
Thanks