Display recordset object from checkbox value in updatable form

[ceeleelewis]

Hello...

I have this nagging issue with checkboxes that I just can't seem to get a grip on.

I have a form with two tables. One table pulls information from one tbl and displays (which works fine).The main issue is with the checkbox fields. I used the following code for the checkboxes to acheive my objective...

<td width=&quot;67&quot;> <table border=&quot;1&quot; width=&quot;11%&quot; cellspacing=&quot;0&quot; bgcolor=&quot;#FFFFFF&quot; bordercolorlight=&quot;#cccccc&quot; bordercolordark=&quot;#cccccc&quot;>
<tr>
<td width=&quot;100%&quot; >
<% if xDNS = &quot;yes&quot; then %>
<input type=&quot;checkbox&quot; name=&quot;DNS&quot; value=&quot;yes&quot; checked=&quot;checked&quot; />
<%else%>
<input type=&quot;checkbox&quot; name=&quot;DNS&quot; value=&quot;yes&quot;/>
<%end if %> </td>
I tried this, but I am not getting any results ... I have fields displaying from another table on the same form.

I look inside the db and see the results of the value.
The only difference between the two tables is the fact that fields that I want users to enter info are referencing the recordset object. (i.e.: xDNS = objRS(&quot;DNS&quot)

I also used a response.write(objRS(&quot;DNS&quot) to check out what's going into the db...

Could there be an issue with my datatype or extra spaces in my text string? At first, I used checkboxes for yes/no in Access but due the constant provider errors. I swithed the datatype to text.

Again thanks for the guidance on this issue.

 

[Falcon99]

Start by replacing &quot; checked=&quot;checked&quot; &quot;
with just checked.

Proper syntax is:

<input type=&quot;checkbox&quot; name=&quot;DNS&quot; value=&quot;yes&quot; checked>

HTH