Form Checkbox If yes Print Associated Report

[naturalsn]

Good Morning

I am hoping someone might possibly assist

I have a very simple DB
1x Table
1x Form
4x Reports

In my table i have four yes/no fields that will indicate the required reports to print (with the specific record)

I have taken the four fields and placed them on the main form as the check boxes. This will be their first entry to the DB

At the end of the form i would like to print all the necessary reports that has been ticked by the user

i have tried the following the following code. by absolutely no luck.

Am i missing something..

Thank you very much in advance for any help

Private Sub cmdPrintReports_Click()

If Me.Recipient = True Then
DoCmd.print "rpt1RecipientCopy"
End If

If Me.Return = True Then
DoCmd.print "rpt2ReturnCopy
End If

If Me.File = True Then
DoCmd.Print "rpt3FileCopy
End If

If Me.Quality = True Then
DoCmd.Print "rpt4QualityReviewEnd"
End If
End Sub

 

[naturalsn]

Hi Everyone..

Thank you so much for the help

It is working

PHV i replaced the syntax with the one listed above. And working perfectly...

Absolutely brilliant...

Thank you very much