Hiding Subforms when no data

[greatwhite]

OK I have several Subforms on a form, I would like to know if there is someway that when the Subform has no data I can hide it and everything sort of shifts up as if the Subform was not there.

[isladogs]

Yes you can but I suggest you make it hidden by default and visible when there is data. For example

If DCount("*","tableOrQueryName", "filter criteria")>0 Then Me.subformcontrolname.visible=True

However if you want the subform to shrunk to nothing when it is empty, combine the DCount with code similar to the example in the link
http://www.mendipdatasystems.co.uk/s...row/4594454012