VB Code:
  1. Private Sub OptShowAll_GotFocus()
  2. On Error GoTo OptShowAll_Err
  3.  
  4.     DoCmd.Echo False, ""
  5.     DoCmd.Hourglass True
  6.     cmbxFilter = ""
  7.     DoCmd.Close acReport, "MonthlyReconciliations(CndExcel)"
  8.     DoCmd.OpenReport "MonthlyReconciliations(CndExcel)", acViewPreview
  9.     DoCmd.Maximize
  10.     DoCmd.RunCommand acCmdFitToWindow
  11.     DoCmd.Close acForm, "ReconciliationsFilter(CndExcel)"
  12.    
  13. OptShowAll_Exit:
  14.     DoCmd.Echo True, ""
  15.     DoCmd.Hourglass False
  16.     Exit Sub
  17.  
  18. OptShowAll_Err:
  19.     MsgBox Error$
  20.     Resume OptShowAll_Exit
  21. End Sub

The line:
DoCmd.Close acForm, "ReconciliationsFilter(CndExcel)"

Error Message:
"This action can't be carried out while processing a form or report event."

I think this is because of the OpenReport method. My report never opens properly. What other way can I open a report?