title | ms.assetid | ms.date | ms.localizationpriority |
---|---|---|---|
Hide a subform if the main form contains no records |
20482340-0c86-71c9-3ba1-b9f515397fbc |
09/21/2018 |
medium |
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
[!includeSupport and feedback]