The OpenReport action was cancelled

[Paul H]

This message is the result of clicking an Open Report button and gives no clue what the problem is.

"The On Open event produced the follow error:
The expression may not result in the name of a macro, funtion or event procedure.



I'll save you the gory details, but I have to comment out the code in On Open and On Format before the report will open. I also get a less fatal error with the on load event, but the report still opens. Of course commenting that out eliminate all the errors except I lose functionality in the report.

Here's the catch. This report usually opens without a hitch. Once or twice a week this problem crops up and is always cured by doing a compact and repair. Today this is not fixing the problem. What's more this does not happen on my coworker's computer.

I can probably hack my way through this, but I'm concerned about the underlying problem. Oh yeah, here the "offending" code. It's pretty tame stuff

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
If Me.Submission_Type_ID = 7 Or Submission_Type_ID = 8 Then
Me.txtStatus_Date.Visible = False
Me.txtStatus_Type.Visible = False
Else
Me.txtStatus_Date.Visible = True
Me.txtStatus_Type.Visible = True
End If
End Sub
 
Private Sub Report_Load()
If IsNull(Form_frmReports.cboCompany) Then
Me.Filter = ""
Else
Me.Filter = "Company_ID = " & Form_frmReports.cboCompany
Me.FilterOn = True
End If
End Sub
 
Private Sub Report_Open(Cancel As Integer) 
DoCmd.Maximize
End Sub

[pdebaets]

Try this:

Private Sub Report_Load()
If IsNull(Forms!frmReports!cboCompany) Then
Me.Filter = ""
Else
Me.Filter = "Company_ID = " & Forms!frmReports!cboCompany
Me.FilterOn = True
End If
End Sub

If that doesn't work, try a decompile and/or Access repair/resinstall. For more information on these, please see http://peterssoftware.com/t_fixerr.htm

[Paul H]

I don't see any difference between your code and mine.

Also, FYI, I imported a backup copy of my report which work's perfectly, for now.

[pdebaets]

The difference is

Forms!frmReports!cboCompany

[boblarson]

I don't see any difference between your code and mine.

Also, FYI, I imported a backup copy of my report which work's perfectly, for now.

Do NOT use the syntax Form_FormNameHere.ControlName

Use the Forms collection - Forms!FormNameHere.ControlName

using Form_FormNameHere is potentially bad and can cause some nasty side-effects.

[Paul H]

Ah, old people eyes at work.

Thank you, Peter and thank you Bob for the explanation. I never knew that it mattered. I'll let you know when I get it sorted out.

Paul