checkboxes that are "synchronized" but don't want that behavior

[Joseph Greenberg]

I have a child subfomm that "repeats" based on the number of records it
finds in the query which is the recordsoure (sorry if I don't have the
terminology exactly correct). The form has a header, and detail. I just
inserted a checkbox on the form, and now when I run the form, whenever I
check the checkbox on one of the records, it checks them all - they are all
synchornized. Is there a way to keep each record on the subform independent?
Note that the checkbox is not bound to anything, it would be used for a
calculation when a command button on the form is clicked.

Thanks in advance.

J

 

[Mike Painter]

You have placed an unbound checkbox on the form.
If there is a "yes/no" (Boolean) field in the table, bind it to that.
If not you will have to add one to the table and then to the query the
form(s) are based on.

 

[John W. Vinson]

I have a child subfomm that "repeats" based on the number of records it
finds in the query which is the recordsoure (sorry if I don't have the
terminology exactly correct). The form has a header, and detail. I just
inserted a checkbox on the form, and now when I run the form, whenever I
check the checkbox on one of the records, it checks them all - they are all
synchornized. Is there a way to keep each record on the subform independent?
Note that the checkbox is not bound to anything, it would be used for a
calculation when a command button on the form is clicked.

Thanks in advance.

J

Data is not stored on forms. There is no "record on a form" or "record on a
subform" - there are records IN TABLES, and the form and subform are just
windows to display the records, in the tables.

An unbound control on a form is just that: it's not tied to any record, it's
not stored anywhere, it just stays in its last state until it's changed.

If you want a checkbox value to be associated with a record then you must
change the design of the table to include a yes/no field and bind the checkbox
to that field.