Retaining values in check boxes

[Eiolon]

I have a form and one field is a check box. When someone checks the box it submits it to the database as YES and if it remains unchecked it means NO. My problem is if someone has made a check in the box, and then later uses the update form, the box is unchecked. I used the bindings tab to make sure the database queried the box just like a normal text field but it doesn't seem to keep the box checked when it calls the record up. Any ideas?

Using PHP/MySQL/DW8

[Newsgroup_User]

Eiolon wrote:
> I have a form and one field is a check box. When someone checks the box it
> submits it to the database as YES and if it remains unchecked it means NO. My
> problem is if someone has made a check in the box, and then later uses the
> update form, the box is unchecked.

Select the checkbox, and then click the Dynamic button in the Property
inspector. In the Dynamic Checkbox dialog box, click the lightning bolt
icon to the right of Check if, and select the correct field from your
recordset. Enter the value you want it to equal in the Equal to field.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/