ASP w/SQL Form variable question

@angelIII is actually one of the bests around here, someone I have learned alot from and he is actually telling you what I think is a pretty good approach.

However, here is another angle and I may off from what you need here.

Here is the code and i will explain at the bottom what I *think* I understand you are trying to do.

<%
set cnntypeDB = server.CreateObject("ADODB.Connection")
set objRS =server.CreateObject("ADODB.Recordset")
cnntypeDB.ConnectionString= "Provider=microsoft.jet.oledb.4.0;Data source=" & server.mappath("Paging.mdb")
objRs.CursorLocation = 3
cnntypeDB.Open

strSQL = "SELECT * FROM Personnel WHERE Status='A' order by LastName, FirstName, MI;"

' Create and open recordset object using existing connection
Set rstequip = Server.CreateObject("ADODB.Recordset")
rstequip.Open strSQL, cnntypeDB, adOpenForwardOnly
If rstequip.EOF Then
%>
	<span  class=middletitle style="font-size: small; font-weight: bold;">
	&nbsp;No records available	</span>
<%
Else%>
<!-- get your names into recordset, assign variable and loop through them.-->
<TABLE>
<TR >
          <TD>&nbsp;Full Name, </TD>
          <TD>Department</TD>
          <TD>Email</TD>
</TR>
<%  'Loop and assign values to variables

	Do Until rstequip.EOF
		personnelID=   rstequip("personnelID")
		Email=   rstequip("Email")
		Dept=   rstequip("Department")
		lName	=   rstequip("Lastname")
		fName	=   rstequip("firstName")
		MidInitial	=   rstequip("MI")
       fullName = UCase(Left(lname,1)) & Mid(lname,2) & ", " & UCase(Left(fname,1)) & Mid(fname,2)& "&nbsp;" &midInitial


%>
<form method=post>
	<input type="hidden" name="personnelId" value="<%=personnelId%>">
<TR>

   <TD><input name=fullname size=15 value="<%=fullname%>"></TD>
   <TD><input name=dept size=15 value="<%=dept%>"></TD>
   <TD><input name=email size=15 value="<%=email%>"></TD>
   <TD>
<%  'Get dropdown
      SQLstmt = "SELECT * FROM Personnel WHERE Status='A' order by LastName, FirstName, MI"
           set personnelSet = cnntypeDB.Execute(SQLstmt)
            %>
            <select name="RptName">
            <option value="">&nbsp;</option>
            <%
             Do Until personnelSet.EOF
             personnelID = personnelSet("lastname") & ", " & personnelSet("firstname")& " " & personnelSet("mi")

             If personnelID = RptName Then sel = "SELECTED" Else sel = ""
            %>
            <OPTION Value="<%=ResultID%>" <%=sel%> > <%=fullname%>
           <%
            personnelSet.MoveNext
            Loop

            %>

          </select>
      </TD>
<%
		rstequip.MoveNext
	loop
%>
</TR>
</form>
</table>

<%
end if
rstequip.Close
%>

Select all Open in new window

This part of the code below:

<%  'Loop and assign values to variables

      Do Until rstequip.EOF
            personnelID=   rstequip("personnelID")
            Email=   rstequip("Email")
            Dept=   rstequip("Department")
            lName      =   rstequip("Lastname")
            fName      =   rstequip("firstName")
            MidInitial      =   rstequip("MI")
       fullName = UCase(Left(lname,1)) & Mid(lname,2) & ", " & UCase(Left(fname,1)) & Mid(fname,2)& "&nbsp;" &midInitial

you will have to get from your main table.

In other words, instead of selecting from personnel table, you select I *think*, email and dept from your main table.

Then on the dropdown section, I would either copy the code from your include into the section where I put it on this test code OR I copy this dropdown code into your include file if you are going to be using it in more than one place.

Notice the personneId as a hidden form field in between the <FORM>...</FORM> tag.

Then on your processing page, you will pass them along:

email = request("email")
dept = request("dept")
name = request("fullname")
personnelId = request("personnelid")

then

your update or insert or delete codes here here.

Again, I could be completely off what you are attempting to do.