see this thread for details:
showthread.php?t=15535
the idea is to create a recordset to lookup the entered email address.
If the address is found, the number of rows returned will be 1 or more, so use numeric validation to make sure the number of rows returned in the record is 0. The recordset will still be empty if nothing is entered so it will allow a blank value.