How to: Hide a Subform if the Main Form Contains No Records

  • Article
Access Developer Reference

The following example illustrates how to hide a subform named Orders_Subform if its main form does not contain any records. The code resides in the main form's Current event procedure.

  Private Sub Form_Current()

With Me![Orders_Subform].Form

    ' Check the RecordCount of the Subform.
    If .RecordsetClone.RecordCount = 0 Then
    
        ' Hide the subform.
        .Visible = False
    
    End If
End With



End Sub