Error when printing reports while running MDE but not MDF

[matt753]

This problem only occurs when running from the MDE file, works perfectly fine when trying it from the original MDF.

I have a command button that prints a report, except after pressing it, a error comes up: "The expression On Click you entered as the event property setting produced the following error:The OpenReport action was cancelled."

Does anyone have any idea what this could be from?

[missinglinq]

If you need help in trouble-shooting code, it's a good idea to actually post the code!

Linq ;0)>

[DataAnalyzer]

Could the report not have data? Do you trap the NoData event in the report?

[matt753]

Heres the code:

Dim rs As Recordset
    
    Set rs = frmsubAdminEdit.Form.Recordset
    
    rs.MoveFirst
    Do Until rs.EOF
    
        If rs(7) > 0 Then
        
            DoCmd.OpenReport "rptInvoice", acViewNormal, , "OrderID=" & rs(0), , False
            rs.Edit
            rs(6) = -1
            rs.Update
        
        End If
        
        rs.MoveNext
    
    Loop
    
    Set rs = Nothing

Again, error when clicking this button happens only when the front end is a MDE, works fine when its a MDB. Error is: "The expression On Click you entered as the event property setting produced the following error:The OpenReport action was cancelled."

[matt753]

The report DOES have data in it

[matt753]

Any ideas anyone?

Has anyone else ever had weird issues that only happen in an MDE and not the MDB?

[DataAnalyzer]

What's the error code? Looks like a NoData problem to me when you try to open the report. Does the NoData event trigger in the report when you run this? A simple MsgBox would be able to tell you.

[matt753]

It was actually due to an error in the code I had when the report was opening. It just didnt show that when doing it in this loop. Only when opened indiviudally.