Problem with Checkboxes

[stevem2004]

Hi,
I have a Access DB where users can fill in checkboxes when they fill in the form, however when I try to edit this form, how can I show them what has been selected in the checkboxes?

I have been trying to use the following code:-

<input name="mediasource" type="checkbox"<%if rs("mediasource") = "Mailing" then Response.write " checked" end if%>>Mailing<br>
But this doesn't show which check boxes have been ticked.

I have about 20 checkboxes in this group. Is the code above wrong??

TIA

Steve

[gil davis]

If you view the source HTML, do you see the correct HTML?

If not, you have a problem in your compare. Perhaps rs("mediasource") is not a string value.

[stevem2004]

Yes, the source is correct

[buntine]

QueryString variables can only be strings. ASP is for very lazy developers. ;)

The reason it is not working is because checkBoxes will return the string "on" if they have been checked.

Regards,
Andrew Buntine.

[Illufox]

I ran into the same problem. Here is the solution:

<input <%If (CStr((RecordsetName.Fields.Item("mediasource").Value)) = CStr("True")) Then Response.Write("checked") : Response.Write("")%> type="checkbox" name="mediasource" value="Yes">

[buntine]

Just a note, you dont need to use CStr() on explicit string like "True". ;)

[stevem2004]

Thanks everybody for your help, much appreciated