I am building an Add routine to add Project Status.<BR><BR>User select project name from project file. I want to read the Project Status to make sure there is not a Status record for this project.<BR><BR>How do I handle the "record not found" condition. <BR><BR>This code includes "On Error Resume Next" to by pass the recordset not found. But I need to set a switch to "new" or something.<BR><BR> Else<BR> Response.Write Request("Project")<BR> Set Conn = Server.CreateObject("ADODB.Connection")<BR> Conn.Open Application("ProjMgr") <BR> MySQL = "SELECT * FROM WkStatus WHERE (Project) = &#039;" & Request("Project") & "&#039;"<BR> Set RS = Conn.Execute(MySQL)<BR> On Error Resume Next <BR> Response.Write RS("Project")<BR> On Error Resume Next <BR> if Err.Number &#060;&#062; 0 Then <BR> error=Err.Number<BR> Err.Clear <BR> fileAction = "New"<BR> daterptd = RS("DateRptd")<BR> else<BR> fileAction = "Change"<BR> daterptd = FormatDateTime(Now,2)<BR> end if<BR> %&#062;<BR>