Checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Main Form checkbox toggles many subform checkboxes 9
Pls Help - Checkbox not updateable 2
change label format based on control it is attached to 2
Combobox controled by checkbox 2
Update Parent form Control 6
conditional formatting of a textbox on a continuous subform 3
change textbox to checkbox 5

Back
Top