Hide Main Report

[SUN]

How to hide main report if there is no data in the subreport?

 

[James Dudden]

You will have to test for a null value in the sub report when the form opens then you could hide the detail etc e.g.

Sub Form_Open
If IsNull(Me!SUBFORM_VALUE) Then
Me!Detail.Visible = False
Else
Me!Detail.Visible = True
End if
Close Sub

That should get you started.

 

[SUN]

Thanks for your reply.

Could you mind elaborate a little bit more as I cannot get it work

 

[wiklendt]

SUN, you need to provide more detail. what have you tried and what is it doing if not the right thing?

that is - HOW is it "not working" - are you receiving any error messages? have you got the code in the right place? etc etc