Checkboxes - How do they work? 2

[jossimon]

I have a form (FrmLabels) and a subform (sFrmLabels). I want to put a checkbox on the subform and then print labels for the lines where the checkboxes are checked. How do checkboxes work? How do I know on the backend if they are checked or not. I have inserted the checkboxes but when I view the form there is no way to check them. Please help.

 

[GingerR]

checked = YES/TRUE/-1 and Unchecked = NO/FALSE/0.

You should add the check box (Yes/No field) to your table. Then display this field in your subform. Try that and see how it goes.

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

checkbox on the subform and then print labels for the lines where the checkboxes are checked

Have you added the check boxes to your table design? Or did you just add check boxes to the form / subform?

Adding checkboxes to a form may work, but you have to code for each check box -- not recommended. These check boxes would be "unbound" meaning that the check box object is not associated with a data record in a table.

Adding checkboxes to a subform would be very difficult to get it to work. Checking an unbound check box object on a subform would check all check boxes displayed.

If you are trying to design a system per your objectives, I feel the best approach would be to ensure your design includes the check boxes. In the table design setup, these are referenced as Yes/No, but from a programming presepctive, we refer to them as boolean variables.

Why dont you post back with more info.

Richard