Working with checkboxes and database

[sthmpsn1]

I have a database where I want the box to load checked if a 1 is in the database field and unchecked if it is 0. Here is the code I am using and it doesn't work, any suggestions.

<input <% if dbrs2.Fields.Item(&quot;goalsmidsupapprove&quot.value = &quot;1&quot; Then Response.write(&quot;1&quot : Response.Write(&quot;0&quot%> name=&quot;supercheck&quot; type=&quot;checkbox&quot; id=&quot;supercheck&quot; value=&quot;1&quot;>

 

[jlsmithhartfiel]

Try this...

<input <% if dbrs2.Fields.Item(&quot;goalsmidsupapprove&quot.value = &quot;1&quot; Then Response.write(&quot; checked&quot : Response.Write(&quot;&quot%> name=&quot;supercheck&quot; type=&quot;checkbox&quot; id=&quot;supercheck&quot; value=&quot;1&quot;>