Hide textbox on parent

[CJ]

Hi Groupies

I used the On No Data event on my subreport so that if it has no data, it
does not print. However, if the sub does not print, I also want two text
boxes on the main report to not be visible either.

I have entered the following code in every event that I can think of, with
no luck.

If Me.rsubReconcileOnGround.Report.Visible = False Then
Me.txtBoxesAfterRec.Visible = False

Any ideas?

 

[Duane Hookom]

I wouldn't use code. Try control sources like:
=IIf(subrptctl.Report.HasData,[previous control source],Null)

 

[CJ]

Hi Duane, thanks for the speedy response.

I was about to respond back with "Where do I enter the IIF
statement?".....then I had a thought.

I entered the following in the OnPrint event:

If Me.rsubReconcileOnGround.Report.HasData Then
Me.txtBoxesAfterRec.Visible = True
Else
Me.txtBoxesAfterRec.Visible = False
End If

Works perfectly!

Thanks for steering me in the right direction with the "HasData" property.
--
Thanks for the brainwaves!

CJ
--------------------
I blame the parents

I wouldn't use code. Try control sources like:
=IIf(subrptctl.Report.HasData,[previous control source],Null)
--
Duane Hookom
Microsoft Access MVP

Hi Groupies

I used the On No Data event on my subreport so that if it has no data, it
does not print. However, if the sub does not print, I also want two text
boxes on the main report to not be visible either.

I have entered the following code in every event that I can think of,
with
no luck.

If Me.rsubReconcileOnGround.Report.Visible = False Then
Me.txtBoxesAfterRec.Visible = False

Any ideas?