Checkbox values return

<i><b>Originally posted by : raj (rajkedda@hotmail.com)</b></i><br /><br />I have an access database with 5 tables. One Table(Departments) has all static values(say Department1,Department2,Department3,Department4) and another table where u keep track of documents belonging to department(s). There is a form on the Intranet Web page with departments being shown as check boxes via populating the checkbox from db. When a user submits, the new record routines writes the values of the checkboxes to db successfully. The values are say Department1,Department3,Department4(if these check boxes were selected). The record field has values Department1,Department3,Department4 stored in it. That is exactly what I want. The problem I am having reading it back with these 3 check boxes selected and others(for example department2 or any other additions to the static table) unchecked. I would really appreciate if somebody can help me on this.<br /><br />

<i><b>Originally posted by : victor (vmouline@home.com)</b></i><br />If you want a checkbox to be checked when form is loaded, use attribute CHECKED<br /><input type='checkbox' CHECKED><br /><br />When you write your server-side routine, use something like this:<br />dim checked<br />if rs.fields("yourField").value = "Department1" then<br /> checked = "CHECKED" <br /> else<br /> checked = ""<br />end if<br />response.write"<input type='checkbox' " & checked & ">" & vbNewLine<br /><br />------------<br />raj at 9/25/2000 3:04:16 PM<br /><br /><br />I have an access database with 5 tables. One Table(Departments) has all static values(say Department1,Department2,Department3,Department4) and another table where u keep track of documents belonging to department(s). There is a form on the Intranet Web page with departments being shown as check boxes via populating the checkbox from db. When a user submits, the new record routines writes the values of the checkboxes to db successfully. The values are say Department1,Department3,Department4(if these check boxes were selected). The record field has values Department1,Department3,Department4 stored in it. That is exactly what I want. The problem I am having reading it back with these 3 check boxes selected and others(for example department2 or any other additions to the static table) unchecked. I would really appreciate if somebody can help me on this.<br /><br />