Checkbox

I have a form with multiple checkbox controls named Delete, Append, Update,
etc, The source for each control is a select statement such as

Select Status from Tbl_Menu_Items where Name = "Delete"

Status has the value of -1 or 0


How do I get the individual checkbox controls to display (Yes/No) that
reflects their status in the table. I want to updatethese controls when I
open my form.

Thanks for the help

Hi Rafi,

If you want a checkbox to format as Yes/No, then have it as a text box
control with the Format set to Yes/No.

If you have the source set as per your description, the checkboxes should be
updating when you open your form already.

Damian.

"Rafi" wrote:

I have a form with multiple checkbox controls named Delete, Append, Update,
etc, The source for each control is a select statement such as

Select Status from Tbl_Menu_Items where Name = "Delete"

Status has the value of -1 or 0


How do I get the individual checkbox controls to display (Yes/No) that
reflects their status in the table. I want to updatethese controls when I
open my form.

Thanks for the help