Hide subform if no data in subform

[snuffi01]

I have an form with an subform called "Forstasidanaktuellt underformulär".
I want that subform to hide if i dont got anything to show. (if no data in subform then you cant see the subform).
I have tried this from an thread in this sitebut it doesnt work (Select one field in each of the subforms that need to be populated for you to want it to be visible and enter in the OnCurrent event:
If IsNull(SelectedFieldName) Then
Me.SubForm1Name.Visible = False
Else
Me.SubForm1Name.Visible = True
End if
)
Please help me!

 

[TonyJollans]

Hi snuffi01,

Try checking the record count of the subform instead ..

If Me.

SubFormControl

.Form.RecordsetClone.RecordCount = 0 Then

...

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[adamroof]

In the subform properties
in the Data tab
set all the Allows to No

Throw in an "Add New" button and nav controls for when it does show.