Help!
Whenever I try to open my database I get the following error:
Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report.
The following line is highlighted:
Me.TabCtl88.Pages ("ROTO-Weehawken").Visible=Me.Services_Key.Form.chkROTO_Weehawken.Value
Below is the complete code:
Private Sub Form_Current()
Me.List367.Selected(Me.List367.ListCount) = True
Me.TabCtl88.Pages("ROTO-Weehawken").Visible = Me.Services_Key.Form.chkROTO_Weehawken.Value
Me.TabCtl88.Pages("ATS-Weehawken").Visible = Me.Services_Key.Form.chkATS_Weehawken.Value
Me.TabCtl88.Pages("Certification").Visible = Me.Services_Key.Form.chkCertification.Value
End Sub
CLIENTS: current Form
List367: list on Form CLIENTS
TabCtl88: main Tab
ROTO-Weehawken: Tab 2 name
chkROTO_Weehawken: check box on Services_Key to make Tab visible
Services_Key: subform on Form CLIENTS
ATS-Weehawken: Tab 3 name
chkATS_Weehawken: check box on Services_Key to make Tab visible
Certification: Tab 4 name
chkCertification: check box on Services_Key to make Tab visible
Whenever I try to open my database I get the following error:
Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report.
The following line is highlighted:
Me.TabCtl88.Pages ("ROTO-Weehawken").Visible=Me.Services_Key.Form.chkROTO_Weehawken.Value
Below is the complete code:
Private Sub Form_Current()
Me.List367.Selected(Me.List367.ListCount) = True
Me.TabCtl88.Pages("ROTO-Weehawken").Visible = Me.Services_Key.Form.chkROTO_Weehawken.Value
Me.TabCtl88.Pages("ATS-Weehawken").Visible = Me.Services_Key.Form.chkATS_Weehawken.Value
Me.TabCtl88.Pages("Certification").Visible = Me.Services_Key.Form.chkCertification.Value
End Sub
CLIENTS: current Form
List367: list on Form CLIENTS
TabCtl88: main Tab
ROTO-Weehawken: Tab 2 name
chkROTO_Weehawken: check box on Services_Key to make Tab visible
Services_Key: subform on Form CLIENTS
ATS-Weehawken: Tab 3 name
chkATS_Weehawken: check box on Services_Key to make Tab visible
Certification: Tab 4 name
chkCertification: check box on Services_Key to make Tab visible