Error message for no results in parameter query

[jnr927]

This may be a really dumb question, but those are the easiest to answer right?

Anyway, I have a parameter query where the user enters in certain criteria that it wants to look up. If there are no results that pertain to what a user enters in, is there a way that I can put in an error message that tells them that there are no results? Right now it just goes to a blank form/report/table (depending on what they are searching). I'd like something to pop up telling the user that there is no information cooresponding with what they've typed in.

Thanks.

 

[VanRoekel.Clint]

No Data

Try to use the HasData variable in your report and print "NoData" rather than "#Error".

=IIf(Not ([HasData]),"NoData")

 

[jnr927]

Thanks - I'll give it a try!