Unanswered: Conditionally hiding subform code works except for one Label
The following code works to hide a subform on a main form based on whether a check box is checked or not, except when I print preview and subsequently print, one label on the subform displays on all records regardless of whether the subform is visible or not.
Private Sub Form_Current()
If Me.SpecialInstructions = False Then
Me.PaperGradeSetUpTablesbfrm.Visible = False
If Me.SpecialInstructions = True Then
Me.PaperGradeSetUpTablesbfrm.Visible = True
I have tried changing it to a text box. I've deleted it and re-inserted it. I've tried moving it onto the main form and recoding it as per below.