Check Box Creation

[Sri99]

HI

I want to modify one report as "I have 3check boxes, when I select one then others should disable and the report I selected should be generate"
so I have to create additional check box. can any one let me know the code to create & generate the report by seleted check box.

Thanks & Regards
Sri

 

[Pat Hartman]

The simplest solution is an option group. Access takes care of ensuring that only one option is selected. Then your code would use a case statement to set the report name.

Select Case Me.fraReportSelection
    Case 1
        strReportName = "rptFirstReport"
    Case 2
        strReportName = "rptSecondReport"
    Case 3
        ....
    Case Else
        MsgBox "Please select a report",vbokOnly
        Exit Sub
End Select
DoCmd.OpenReport strReportName,...whatever other options you need..