Where is your form? You need to post a form to the page to all this to work:
CompanyID_Merge=Request.Form("CompanyID_Merge")
without a form this can not work. You need a form tag, submit button. Then move your ASP to the top of the page and check of the form collection has a value e.g:
Code:
<%
if trim(Request.Form("CompanyID_Merge")) <> "" then
CompanyID_Merge=Request.Form("CompanyID_Merge")
Conn.Open strConn
SQL = "SELECT Projects.CompanyID, Projects.ProjectID, Projects.ProjectName, Projects.SeasonYear, Seasons.Season, " & _
"Activities.ActivityName WHERE Projects.CompanyID = " & CheckNumber(CompanyID_Merge) & ";"
SET RS = Conn.Execute(SQL)
else
response.write "There is nothing in the form collection to process...."
end if
%>