Automated Alert/Message Box

[isladogs]

OK I'm back from the pub ... actually I've just been busy on other posts.

I've just re-tested the cmdAll_Click code and it runs perfectly for me with no errors.

So I think the issue is elsewhere in your db rather than in my code

Try Paul's suggestion & if that doesn't work, suggest you upload your db for one of us to look at