Can you explain the use case? You want it to fail validation if the email address doesn't already exist? The way to do that is to create a recordset filtered by the submitted email address and then validate the number of rows in the recordset is greater than 0 using numeric validation. You just have to manually move the recordset above the validation code since it will be placed below by default.