how to set up an error message if criteria is false in a query ?

[Hapr1]

How to display an error message if the specified criteria is false in a query ?
what function should be used for that ?
I have a query which has to check 3 conditions and if the 3 conditions are true then it should display an error message .
What should be done for that?

Thanks for your help in advance

 

[Pat Hartman]

Queries don't interact with the user except to prompt for parameters. If you are using the query as the RecordSource for a report, you can use the NoData event to display a message. Forms don't have a NoData event but you can determine if the recordset is empty by checking the recordCount in the form's Load event.