simple error message "problem"

Hi,

I have this update page. The user enters in a record to be updated on a form. The page then displays the record to be updated. I am trying to add a error message to check if what the user typed in doesn't match anything in my database. I have an if statement to do the error checking. It works when the user enters in a record that doesn't match one in my database. The if statement fails when the user enters in a record that matches in the database. The error message "that record doesn't exist!!" appears when the records do match, the matching record appears along with the error message. Here is my if statement. Can anyone help?

if trim(ucase(request.form("frm_title"))) <> trim(ucase(rs.fields("title"))) then
     response.write("that record doesn't exist!!")
     %><br><%
end if


Thanks,

Amisima

Hi,

I am not familiar with the strcomp function. Would you be able show me what the syntax would look like. I really appreciate the help.

Amisima