Print specific report based on form check boxes

[Eddy Sincere]

I can't find this answer anywhere. There are three check boxes on my form, 1, 2 and 3.



And, there are 3 different report templates, A, B and C.

I want access to determine which report to print based on which check boxes are checked.

Example 1:
Check Box 1 = Null
Check Box 2 = Check
Check Box 3 = Null
Choose Report A

Example 2:
Check Box 1 = Check
Check Box 2 = Check
Check Box 3 = Null
Choose Report B

If this is possible, please direct me to the code. Thanks!

[CJ_London]

if check1=true then
    printreport
end if
if check2=true then
    printreport
end if
if check3=true then
    printreport
end if

[Eddy Sincere]

Thanks! I'll give it a shot and let you know if it works.

[Eddy Sincere]

Worked like a charm. In case someone else reads my post, here's the actual VBA I used. It basically chooses a report based on a combination of two check boxes. Thanks again for the quick response. Please mark this as solved.



Private Sub cmdPrnt_Click()


On Error GoTo cmdPrnt_Click_Err


If DtrySpplmnt = True And VtmnMnrl = True Then


DoCmd.OpenReport "rpt1ADSC", acViewPreview, "", "", acNormal
DoCmd.RunCommand acCmdPrint


cmdPrnt_Click_Exit:
Exit Sub


cmdPrnt_Click_Err:
Resume cmdPrnt_Click_Exit


End If


If DtrySpplmnt = True And VtmnMnrl = False Then


DoCmd.OpenReport "rpt1BDSOC", acViewPreview, "", "", acNormal
DoCmd.RunCommand acCmdPrint


End If
End Sub