No Records #Error Null 1

[RachelK]

Hi,

I am running a report that I have created from a form and a query. If the citera that the user selected had no records for example there no reocrds being to the name they have selected in a certain area. I would like a message to appear and the report to not run when there's no records any idea's?

Cheers Rachel.

 

[glalsop]

Hi Rachel -

Have a look at faq703-1594

Good luck

-Gary

 

[RachelK]

Gary,

Thank you it worked perfectly. I did have a look through existing records but missed that one.

Cheers Again Rachel.