Ok I don’t know if this is the best place to ask this, but I figured that you’re all pretty smart people and there’s a fairly good chance of someone being able to help me out. [COLOR=black](also, I’m not sure if there’s a more appropriate section, but I couldn’t see it…)[/COLOR]
So I’ve got a report in access that lists the results of a query. What I want to do is to have some sort of error message if there’s no results in the set.
My first instinct was to have a Text box which showed how many entries there were and so the user would be ableto see if it was 0. I had this as the ‘control source’ :
=Count([CuttingID])
That works fine except that if there’s no results, it shows #Error and I can’t work out a way of getting it to count the results, even if there aren’t any.
Is there a way to do what I’m trying to do, or even better, an (easy) way to have say a pop up message tell the user that there’s no results.
As you can guess, I’m not that confident in Access so I’m a bit stuck.
Thanks!
Edit:
OK I’ve got it now - had to add an IF into the button on the form that calls the query.
Nice excuse to come back to KF though :sc:
