custom message based on query results

[Leslie]

I created a query to check for duplicates as the following:
SELECT [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier
FROM [Working Table] INNER JOIN [ALL Policies] ON ([Working
Table].ApplicationNo = [ALL Policies].ApplicationNo) AND ([Working
Table].CustomerNo = [ALL Policies].CustomerNo) AND ([Working Table].Carrier =
[ALL Policies].Carrier)
GROUP BY [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier
HAVING ((([ALL Policies].CustomerNo) Is Not Null) AND (([ALL
Policies].ApplicationNo) Is Not Null) AND (([ALL Policies].Carrier) Is Not
Null));

I would like to send the user a custom message based on query results.
Anyone have any suggestions?

 

[Carl Rapson]

Using a form, run the query in the Click event of a command button and
display messages depending on what the query returns.

Carl Rapson