Hide Subform if no records?

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Hi everyone
Does anyone knows if it is possible to hide the subform i
have in my form in case it has no records?
Tks in advance
Pedro
 
Pedro said:
Does anyone knows if it is possible to hide the subform i
have in my form in case it has no records?


No idea where you should place the code, but here it is:

Me.subformcontrol.Visible = _
Me.subformcontrol.Form.RecordsetClone.RecordCount > 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top