Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    22

    Unanswered: Conditionally hiding subform code works except for one Label

    Hi All,
    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.

    Code:
    Private Sub Form_Current()
    
    If Me.SpecialInstructions = False Then
        Me.PaperGradeSetUpTablesbfrm.Visible = False
    End If
    If Me.SpecialInstructions = True Then
        Me.PaperGradeSetUpTablesbfrm.Visible = True
    End If
    End Sub
    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.

    Any ideas?

    Thanks,
    Dan

  2. #2
    Join Date
    Mar 2010
    Posts
    22
    I found a workaround.

    I put the label on the main form and used an IIf in the control source.

    Thanks,
    Dan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •