Edit not working when using search to display records

As a first step you need to configure your IIS to returned detailed error message to the browser. This is the article that can help:

http://www.iis.net/learn/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/classic-asp-script-error-messages-no-longer-shown-in-web-browser-by-default
Once you get to the actual error message post it here.

Thank you. The error returned is:
Microsoft SQL Server Native Client 10.0 error '80040e31'
Query timeout expired
/odr/include/aspfunctions.asp, line 1243
The section in aspfunctions.asp is:
function db_query(sSQL,conn)

dim asp_rs

if IsIdentical(dDebug,true) then response.write sSQL & "
"

Set asp_rs = server.CreateObject("ADODB.Recordset")

asp_rs.Open sSQL,conn Line 1243

call ReportError

set db_query=asp_rs

end function

It looks like your query takes long time to execute causing SQL Server timeout. Here is the article that explains how to print all executed queries on the web page:

http://xlinesoft.com/asprunnerpro/docs/debugging_tips.htm

First, the debug option is awesome. It will help me fix some Active Directory issues. This is what I receive on the time out:
select GroupID from [dbo].[odr71_uggroups] where Label in ('ESE.CO.Admin','ESE Staff.ESE.CO.Admin','Dist.ESE.CO.Admin','Dist.Departments.CO.Admin','Domain Users','macg')

select TableName,AccessMask from [dbo].[odr71_ugrights] where GroupID in (1)

SELECT [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM dbo.ODR_v2 INNER JOIN dbo.StuSchool ON dbo.ODR_v2.StudentID = dbo.StuSchool.ENRKSTDT where dbo.ODR_v2.ID=2315

SELECT top 1 [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM [dbo].[ODR_v2] INNER JOIN [dbo].[StuSchool] ON [dbo].[ODR_v2].[StudentID] = dbo.StuSchool.ENRKSTDT WHERE ((dbo.ODR_v2.ID<2315 or dbo.ODR_v2.ID IS NULL)) and ((1=1) and (upper(dbo.StuSchool.ENRLAST) like upper(N'%sponge%'))) ORDER BY 3 DESC

SELECT top 1 [dbo].[ODR_v2].[StudentID], [dbo].[ODR_v2].[Incident_Date], [dbo].[ODR_v2].[ID], [dbo].[ODR_v2].[Incident_Time], [dbo].[ODR_v2].[Describe_Behavior], [dbo].[ODR_v2].[Parent_Contact], [dbo].[ODR_v2].[Parent_Contact_Date], [dbo].[ODR_v2].[Parent_Contact_Detail], [dbo].[ODR_v2].[Action_Recommended], [dbo].[ODR_v2].[Incident_Location], [dbo].[ODR_v2].[Possible_Motivation], [dbo].[ODR_v2].[Persons_offending], [dbo].[ODR_v2].[Num_of_Offenders], [dbo].[ODR_v2].[Teacher_Email], [dbo].[ODR_v2].[Admin_Email], [dbo].[ODR_v2].[Consequence_Date], [dbo].[ODR_v2].[Consequence_Date_Thru], [dbo].[ODR_v2].[Num_Days], [dbo].[ODR_v2].[Parent_Phone], [dbo].[ODR_v2].[Parent_Contact_Date_Admin], [dbo].[ODR_v2].[Parent_Contact_Time], [dbo].[ODR_v2].[Parent_Contact_Type], [dbo].[ODR_v2].[Admin_Comments], [dbo].[StuSchool].[ENRLAST], [dbo].[StuSchool].[ENRFRST], [dbo].[StuSchool].[GR], [dbo].[StuSchool].[ETH], [dbo].[StuSchool].[PRIMEXCP], [dbo].[StuSchool].[DOB], [dbo].[StuSchool].[PMSCHL], [dbo].[ODR_v2].[Hours], [dbo].[ODR_v2].[GroupID4], [dbo].[StuSchool].[SCHL], [dbo].[ODR_v2].[TERMS_Empl] FROM [dbo].[ODR_v2] INNER JOIN [dbo].[StuSchool] ON [dbo].[ODR_v2].[StudentID] = dbo.StuSchool.ENRKSTDT WHERE ((dbo.ODR_v2.ID>2315)) and ((1=1) and (upper(dbo.StuSchool.ENRLAST) like upper(N'%sponge%'))) ORDER BY 3 ASC
Microsoft SQL Server Native Client 10.0 error '80040e31'
Query timeout expired
/odr/include/aspfunctions.asp, line 1243

You need to run all those queries manually to find which one may take long time to execute. Then you need to find a way to speed up this query i.e. add indexes etc.

2 good things in one day. First, it turned out to be a bad index. I deleted the indexes and re-added them and it solved the problem. I appreciate being pointed in the right direction.
Second good thing, ASPRunner 7.2 is OUT!!!!! Great product. Thank you for your support and excellent products.