check box field in forms...

[chrissoileau]

I created a form from table data imported from dbIII data.
On the form data, I've added several checkboxes for choosing certain attributes for each individual record. Well, while viewing in datasheet mode, I've noticed that if I select any one checkbox for any particular record, the ENTIRE COLUMN(checkbox field) is also checked. This completely prevents me from assigning the individual attributes I'm seeking to do. Help?? I can't figure how to "unlock" the records in a column(checkbox field).

thanks...

 

[David R]

Make sure the checkbox is actually bound to a field in the table

This is the most common reason for the behavior you're describing. If a field is unbound, it will be the same in all of the records, despite your best efforts.

 

[chrissoileau]

David, what's the quickest way to check if a checkbox is bound to a field?

 

[David R]

Double-click it in Design View

This should bring up the Properties window. (a single click will suffice if Properties is already active). Go to the Data tab and look under Record Source. If it's blank or set to =...., it's not bound. If it is bound, it will list the field it is bound to.

If you're confused, post back here what it says under Record Source, along with an explanation of any arcane terms you think we might not understand (like cboSnarkleblatt42).

 

[chrissoileau]

Thanks. I skimmed over that before will searching for a clue and the "control source" was blank but I didn't know that was the clue for being unbound. Also, when I looked at the fields in the drop down menu, it didn't give me the "checkbox" field that now appears in the datasheet view since the checkbox was created on the form. Is the corresponding column on the data sheet view considered a field? It doesn't come up as a choice for the "control source".
I created the form from a table that was created from imported data. After I added a couple of checkboxes, I noticed that the datasheet view of the form had added columns as the same name of the checkboxes. I figured this would work fairly easy. But then I noticed that the original table the form data was created from didn't have newly added columns like the datasheet view in forms corresponding to the new checkboxes. Is this the problem? How do I add the checkbox columns in the table data the forms where created from???

 

[David R]

To bind a control on a form, there must be a field to bind it to

Think of 'binding' as 'storing' the data. An unbound control (column, in your case) can show a calculated result, or any value you want, but it has nowhere to store that piece of data.

Compare your new checkboxes with other, existing fields on your datasheet that work. You'll see their control source points to a field in the table, where you can go find the data that is stored.

You'll have to add checkbox fields to your table in order to get them bound on your form. Generally speaking, they should be added (for sanity's sake) to the table first, then to any query in between the table and form, then to the form that is based on that table/query. You already have the fields on your form, so just add them to your table and add the appropriate control source in your form. Then try checking them (as in click) and check (as in look) the table for stored results.

All should be well.

 

[chrissoileau]

Thanks. I sort of did this backwards. I was trying to copy the checkbox columns form the form datasheet view and paste them into the original table...which i can't seem to make work. In the process I doubled all the data and really screwed things up so now I'll follow your advice and start over from scratch.

Thanks. Have a happy and safe 4th!