Problem with changing report based on checkbox

Abbos

Registered User.
Local time
Today, 09:01
Joined
May 11, 2005
Messages
64
I have a form with one checkbox on at the moment. Depending on whether it is checked or not I want to choose to display or not display a field on a form.

I have the following code below but whether the checkbox is ticked or not it doesn't affect the report.

Code:
If Check4 = True Then
[Report_Temp].Medium.Visible = False
DoCmd.OpenReport "Temp", acViewPreview, , MyFilter

What have I missed?
 
Have tried a few things but still struggling with this one. Would really appriciate some help.
 
In the AfterUpdate of the checkbox try this

Code:
If Me.Check4 = True Then
Me.Report_Temp.Medium.Visible = False
Else
Me.Report_Temp.Medium.Visible = True
End If

I'm assuming Report_Temp is the field, not sure what "Medium" is though

Col
 

Users who are viewing this thread

Back
Top Bottom