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.
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.
Yes you can but I suggest you make it hidden by default and visible when there is data. For example
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 linkCode:If DCount("*","tableOrQueryName", "filter criteria")>0 Then Me.subformcontrolname.visible=True
http://www.mendipdatasystems.co.uk/s...row/4594454012