Access Reference

Hide a subform if the main form contains no records

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.

“`vb 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 “`

!include[Support and feedback]

6 community Q&A using Hide a subform if the main form contains no records

html parsing of cricinfo scorecards +47
Code to loop through all records in MS Access +46
T-SQL: Export to new Excel file +44
Download attachment from Outlook and Open in Excel +43
Implementing String.Format() in VB6 +37
How to write a cell with multiple columns in xlwt? +35

Libraries that work with Hide (5)

Hidennotare
Ruby, EB and DLL composition
Planet Source Code
vbAccelerator Archive
MS KB Archive

68 wordsMicrosoft Docs rev. 09/21/2018