I'm trying to write a routine that will print a long-form report if a checkbox named chkRCP1 is true and the short-form if it is false. But I keep getting an object required error message. I've tried about 50 different things but nothing seems to work. Maybe I've been looking at this too long and I'm just missing something. Any suggestions?
Private Sub cmdPrintFSEReport_Click()
On Error GoTo Err_cmdPrintFSEInspReport_Click
Dim varDocName As String
Dim CheckRCP As Object
Set CheckRCP = chkRCP1
If chkRCP1.Value Is Yes Then
MsgBox "FSE Inspection Report Long-Form"
varDocName = "FSE Inspection Report Long-Form"
ElseIf ckhRCP1.Value Is No Then
MsgBox "FSE Inspection Report Short-Form"
varDocName = "FSE Inspection Report Short-Form"