I am trying to use variable substitution in the following line and cant get it.
'What I have working:
Forms!frmMain.frmSalesSubForm.Visible = True
X will actually come from the value in a ADODB recordset named "rst", but this should sufice for my example.
'What I want:
dim X
X = rst!SubFormName
Forms!frmMain.X.Visible = True
The error on the ....visible = true statement is
Compile Error:
Method or Data Member not found.
Any help appreciated.
bryan