access mdb vs mde

[gonzosez]

I have an application that I turn into a mde.
The problem is that if there is no data on a report I use the following
function.

Private Sub Report_NoData(Cancel As Integer)
MsgBox "There is no data for the criteria you selected."
Cancel = True
End Sub

works great for the mdb file but blows up when a mde file.
Any ideas?

 

[Joan Wild]

The code should not make a difference whether it's run in a mdb or mde.

Could you please provide more specifics with regard to 'blows up'.

 

[Pat Hartman\(MVP\)]

You need to trap the error (2501 I think) and ignore it.