No Records Found - Show an Error msg

[chloe67]

I have a frame on a form and if you select a radio dial it will run the corresponding query and export the data to an excel file when you click on a button.

My problem is that I also need it to check the data from the query first and if there aren't any records, show an error message and not run the export.

HELP! Thanks for any help in advance!

 

[PHV]

Take a look at the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244