Option Box Code Help Please

[yogi1980]

Hi,
I have a form with an option box. Once the box is clicked a report opens. After I close the report, the form is still there but I do not want the 'black selection dot' to be in the option box; I want it to be empty as it was when the form was first opened. What code is needed for this?
Thanks.

Private Sub Option183_Click()
DoCmd.OpenReport "Rpt_Charges03", acPreview, "", ""
DoCmd.Maximize
End Sub

 

[Matt Greatorex]

Private Sub Option183_Click()
        DoCmd.OpenReport "Rpt_Charges03", acPreview, "", ""
        DoCmd.Maximize
        [Forms]![[I]formname[/I]]![[I]Option183[/I]] = False
End Sub

Should reset it to be clear, after opening the report.

 

[yogi1980]

Thanks Matt. It works. I'm noticing though that when I first open the form, the boxes have a grey back ground to them, instead of being clear. After I click them, they are empty but not when the form firsts opens.
Thanks alot.

 

[geekay]

Open the from in design view. Select the option button. Click View>Properties.
Set the Default value prperty to 0 (zero). Do the same for all the option buttons in question. Save the form. Open it in form view to see the changes

 

[yogi1980]

Thanks a lot, works great.