Easy checkbox question...

[smelly]

I am trying to print a form on Close if a box is checked. What is the best way to go about doing this?
Thanks,
Smelly

 

[pdx_man]

You are better off to have a report that emulates the form you are wanting to print. Forms just don't print that well.

Private Sub Form_Close()

    If Me.TheCheckBox = True Then
        DoCmd.OpenReport "TheReport", acViewNormal
    End If

End Sub

 

[smelly]

Thanks PDX_MAN! Exactly what I needed.