Report No Data Puzzle: Message box displays twice

[kcn]

Hi,

I'm getting the same message display *twice* when I use the no data event:

Private Sub Report_NoData(Cancel As Integer)
msgbox "no records!"
End Sub

If I include a cancel statement (Cancel = -1), the second message that displays is the Access: "the open report action was canceled"

Any ideas what could be going on?

This is Access 2000.

thanks!

 

[PHV]

Have a look at error handler

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kcn]

Thanks. You pointed me in the right direction!