Close a subform if no data

Topic

New Reply

I have a form with 2 subforms. How can I not display a subform if there is no data in it base on the data in the main form?

Reply | Quote

Replies

If the subforms are properly linked to the parent form with the master and child links, they will automatically show up empty if there are not matching records based on the parent form.

Reply | Quote

Thanks for the help. That is working fine, however I would like to make the subform not visible if there is no data for it instead of showing an empty form.

Reply | Quote

You need to put a little code into the OnCurrent event procedure of your parent form.

 Private Sub Form_Current()
  If Me!fsubForm.Form.RecordsetClone.RecordCount = 0 Then
    Me!fsubForm.Visible = False
  Else
    Me!fsubForm.Visible = True
  End If
 End Sub

You’ll have to substitute your subform control name for fsubForm in the code.

Reply | Quote