Hiding & showing a label in a report using a toggle button in a form

F

frunkablunka

Does anybody know how to hide & show a label in a report using a toggle
button in a form?

What I am trying to achieve is displaying some text on a label in a
report when a toggle button in my main form is pressed down. When it is
in the upstate I want the lable to be invisible on the report.


How do I achieve this?

Please :)

My form is called frmProject
My report is called rptJobOverview
My toggle button in frmProject is called tgbTrack
My label in rptJobOverview is called lbltrack

Thanks
 
J

John Spencer

Basically, you need code like the following. You should be able to place
that code in the reports open event

Private Sub Report_Open(Cancel As Integer)
Reports!rptJobOverview!lblTrack.Visible = Forms!frmProject.tgbTrack
End Sub
 
Top