create a recordset to lookup the username that was entered.
Add server validation. Set the server variable to "$totalRows_RecordsetName" where RecordsetName is the name ofthe recordset.
Use number validation. set the minimum to -1 and the maximum to 0.