I am using a parameter query to return the data of an animal, the user will type in the animal ID and the query will return all the data about the animal. This works perfectly. However at the moment if the user inputs an incorrect animal ID the database just returns a blank query. I would like the database when a user inputs an incorrect animal ID to return a simple message box saying that the animal does not exist. I am sure this is a basic question of validation but I am struggling. Any help would be much appreciated.
Query Validation
- Thread starter molly pup
- Start date
