Random error Message box

[badboybrown]

hello,

I have used the advice on this site to clear a specific error when a
report is generated without any data.

Err_cmdLaunchItemsReport_Click:
Select Case Err.Number
Case 2501
Err.Clear
Case Else
MsgBox Err.Number & Err.Description
End Select

However, if the report does have data, I now get a Message Box that has
no heading and only contains a zero, "0". This happens everytime the
report is opened.

What have I done wrong/have I not done?

Really appreciate your help.

[Allen Browne]

Above the code you posted, you forgot to add the line:
Exit Sub
or possibly:
Exit Function

As a result, even with the code runs successfully, the error handling part
is executed too.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"badboybrown" <se*****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

hello,

I have used the advice on this site to clear a specific error when a
report is generated without any data.

Err_cmdLaunchItemsReport_Click:
Select Case Err.Number
Case 2501
Err.Clear
Case Else
MsgBox Err.Number & Err.Description
End Select

However, if the report does have data, I now get a Message Box that has
no heading and only contains a zero, "0". This happens everytime the
report is opened.

What have I done wrong/have I not done?

Really appreciate your help.

[Keith Wilby]

"badboybrown" <se*****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

hello,

I have used the advice on this site to clear a specific error when a
report is generated without any data.

Err_cmdLaunchItemsReport_Click:
Select Case Err.Number
Case 2501
Err.Clear
Case Else
MsgBox Err.Number & Err.Description
End Select

However, if the report does have data, I now get a Message Box that has
no heading and only contains a zero, "0". This happens everytime the
report is opened.

What have I done wrong/have I not done?

Really appreciate your help.

The zero is the contents of Err.Number - there is no error but the code is
running anyway. You need "Exit Sub" before the error handling code.

Keith.
www.keithwilby.com

[badboybrown]

Thanks.

Very much appreciated.

I'm learning as I go...