Option Group on a Report

[Paul H]

I want to put an option Group on a report with two toggle buttons. Here's my code, you'll get the idea.

Private Sub fraDetails_Click()
With Me
If fraDetails = 1 Then
.Detail.Visible = True
.Line_Grandchild.Visible = True
.lblGrandchild.Visible = True
.lblUPC.Visible = True
Else
.Detail.Visible = False
.Line_Grandchild.Visible = False
.lblGrandchild.Visible = False
.lblUPC.Visible = False
End If
End With
 
End Sub

Is this possible? When I check for the valuePrivate Sub fraDetails_Click()

The problem is the Option Group doesn't work. There is no stored value in the properties. Do option groups work on a report? With the level of detail I have to put into the code (more than what you see here), this seems the logical place. My next option is to go back to the form that opens it.

What say you?

[Paul H]

Solved this almost by putting a check on the form and the in the On Open event. It seems to work, but if you've got something to add, please do.

I've got another related question which I'll ask in a seperate thread.