If you are doing your record search via a recordset you should be able to
use the nomatch property.
If rsClone.nomatch Then MsgBox "No records satisfy the specified search
criteria", vbExclamation, "No Match"
I hope this helps.
"Johnny Lui" <jluikeromail.com> wrote in message
| Hi Everyone,
| I'll explain what I'm doing first. At the moment, I am
| doing a record search via a form. I like to know if it's
| possible to display an error message if that record
| doesn't exist. Currently, it displays a blank form which
| isn't too informative for the user.
| If someone could help me with this, it would be greatly
| Thanks in advance.