Basicaly I am using just a simple query that looks like this
SELECT [TBL cac].[LAST NAME], [TBL cac].[FIRST NAME], [TBL cac].ACTIVITY, [TBL cac].LOCATION, [TBL cac].[POSITION TITLE], [TBL cac].GS, [TBL cac].SERIES, [TBL cac].appointment, [TBL cac].GRADE, [TBL cac].Smtp, [TBL cac].DIRECTORATE, [TBL cac].[Naf or APF], [TBL cac].DIVISION, [TBL cac].AKO, [TBL cac].SPONSERED, [TBL cac].[Cac Card], [TBL cac].[Cac Reader], [TBL cac].[Ako Forwarded], [TBL cac].[Cac Verified], [TBL cac].[AKO Email], [TBL cac].Completed
FROM [TBL cac]
WHERE ((([TBL cac].[LAST NAME])=[Enter Last Name]) AND (([TBL cac].LOCATION)="vicenza"

AND (([TBL cac].DIRECTORATE)="dca"

)
WITH OWNERACCESS OPTION;
this query filters for a certain city and prompts the user to enter a last name. I would like a msg box to prompt the user saying no data found if their is no records found with that last name. Thanks for any help would be appreciated.
Tim