ok i have a combo box that i fill from my database of managers name and this references the Managers ID so when the user selects the correct manager it references from the database that managers ID
straight away...and assigns that combobox the managerID value
so on the same form i have a user input where they input there own data and then an insert button that inserts the user data as well as the manager ID Value into the USER Table ..

here is my code but when i do the insert and check the database i get a Null value ????

here is my code help me please ???






While (NOT RsSection.EOF)
%>
<option value="<%=(RsSection.Fields.Item("SectionManagerID").Value)%>" <%if (CStr(RsSection.Fields.Item("SectionManagerID").Value) = CStr(RsSection.Fields.Item("SectionManagerID").Value)) then Response.Write("SELECTED") : Response.Write("")%>><%=(RsSection.Fields.Item("SectionManagerName").Value)%></option>
<%
RsSection.MoveNext()
Wend
If (RsSection.CursorType > 0) Then
RsSection.MoveFirst
Else
RsSection.Requery
End If
%>
</select>