<% Sub Opt1Name() If objRS("Opt1") <> "" Then strOpt1Id = objRS("Opt1") Set oRS2 = Server.CreateObject("ADODB.Recordset") Sql2 = "Select * From Options Where Id = "& strOpt1Id &"" oRS2.Open Sql2, objConn Response.Write oRS2("Name") Else End If End Sub %> <% Sub Opt1Box() %> <% If objRS("Opt1") <> "" Then %> <% Else End If %> <% End Sub %> <% Sub Opt2Name() If objRS("Opt2") <> "" Then strOpt2Id = objRS("Opt2") Set oRs3 = Server.CreateObject("ADODB.Recordset") Sql3 = "Select * From Options Where Id = "& strOpt2Id &"" oRs3.Open Sql3, objConn Response.Write oRs3("Name") Else End If End Sub %> <% Sub Opt2Box() %> <% If objRS("Opt2") <> "" Then %> <% Else End If %> <% End Sub %> <% Sub Opt3Name() If objRS("Opt3") <> "" Then strOpt3Id = objRS("Opt3") Set oRs4 = Server.CreateObject("ADODB.Recordset") Sql4 = "Select * From Options Where Id = "& strOpt3Id &"" oRs4.Open Sql4, objConn Response.Write oRs4("Name") Else End If End Sub %> <% Sub Opt3Box() %> <% If objRS("Opt3") <> "" Then %> <% End If %> <% End Sub %>