Update Form with Combo Box Values

[realgoldn]

I have a form that I use for both editing and adding. When the form is used for editing I load the fields with vaues from the table. When loading the combo boxes I set the option selected to the value of the record but when I click the update button it says my field is null. Why doesn't it recgnize that I loaded/selected a value in the combo box.

[Danial]

Originally posted by realgoldn
I have a form that I use for both editing and adding. When the form is used for editing I load the fields with vaues from the table. When loading the combo boxes I set the option selected to the value of the record but when I click the update button it says my field is null. Why doesn't it recgnize that I loaded/selected a value in the combo box.

It will be hard to say without looking at the code. Post your code if possible..

[mendhak]

Using javascript to check the combobox?

[Matt_T_hat]

I take it that you are aware that comboboxes in HTML forms have two values one that appears and one that is sent? Further these form eliments tend to have ID and Name which is a tad confusing too.

Double check those basic eliments if at all unsure otherwise feel free to ignore me.

[realgoldn]

Hmm one that appears and one that is sent? Maybe I am selected the right one to appear but not to send. How do I do that?

This is how I set up the combo box

<%
set rs=server.CreateObject("ADODB.RECORDSET")

RS.Open "select * from tbl_cap where cip is null order by type,division,id,fy",cn,adOpenStatic,adLockOptimistic
%>
<TR>
<TD>*Cap Number:</TD>
<TD><SELECT size=1 name=cboCapNum style="WIDTH: 105px">

<%
If blnadd Then
Response.Write "<option selected></option>"
End If
Do While NOT RS.EOF
Type1=rs("type")
Div=rs("division")
id=rs("id")
fy=rs("FY")
Response.Write "<option value=""" & Type1 & div & ID & FY & """>" & Type1 & div & ID & FY & "</option>"
RS.MoveNext
Loop
RS.close
set rs=nothing

If Not blnadd Then
Response.Write "<option selected="""& rsItem("Cap") &""">"& rsItem("Cap") &"</option>"
End If

%>

[Matt_T_hat]

Originally posted by realgoldn
Response.Write "<option value=""" & Type1 & div & ID & FY & """>" & Type1 & div & ID & FY & "</option>"

That seems to be over kill. I assume that ID is the unique ID field? so set the vale as "...Value = """ & ID & """>" otherwise you will need to build very big strings to select the record set at the other end.

Might I also sugest that

"Type: " & Type1 & " Div:" & div & " ID:" & ID & ":" & FY

might be simpler to read as out put.

I can't be sure but it seems the problem might be that you over complicated things.

Give it a go and tell us what happened.

[realgoldn]

thanks for your help!