Remove a sub form from main form if sub form has blank fields

[Wayne Viles]

I have several sub forms installed in my main form but there a few sub forms
which have blank fields. Is it possible for the main form not to show any
empty sub forms when viewed.

 

[Arvin Meyer [MVP]]

I have several sub forms installed in my main form but there a few sub forms
which have blank fields. Is it possible for the main form not to show any
empty sub forms when viewed.

You can show or hide a subform:

Me.NameOfSubformControl.Visible = True ' or False

based upon the results of a recordcount. You can also change its height on
the same basis. Forms do not have a CanShrink or CanGrow property like
printed reports, so I might ask if you have thought about what you will do
with the blank space when the subform isn't visible?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access