No it isn't.I've drawn a checkbox beside the field "Name". The checkbox can be edited, but checking one checkbox leads to checking all the checkboxes beside the names in the subform. Similarly, unchecking one check box leads to unchecking all checkboxes beside the names. Is that how a checkbox supposed to function?
Sounds like your checkbox isn't bound to a field.
It should be bound to a Yes/No field so each record can be individually modified.
@Ridders - I was going to suggest that you misread the problem, that the control is behaving as it often does when it's on a continuous form.
@Tipzee - it's because the control is unbound. Pretty sure I mentioned here before that the checkbox field should be bound to a table field, although it was mainly so that the information could be saved. If you could check off a record as being viewed without saving that info in a table, there'd be no point as the check would be gone next time you come back to that record (if the control isn't bound). Bind the control to a yes/no table field and it will behave as you want it to.
Your reply wasn't there when I posted.
Or the email link takes us to a specific post rather than the end of the thread and yours was on the next page. Not sure which. My comment was about your prior post, so don't be confused like me
I think you went backwards in time ...
I think it's a toss up who is more befuddled....
Anyway...we agree ....I think! Hooray!
Thanks everyone! The checkbox was somehow locked when I bounded it to the table that the query and subform was based on, but I've managed to resolve it by adding the additional field in the query. So the checkbox now works!
Separate question, I am intending to create about 15 to 20 subforms in the main form, with each subform based on a different query. Is there a way to allow all subforms to be dynamically sized based on the number of rows of data (which is pulled based on the query) without scroll bars? Similar to how reports can be designed. I have created 2 subforms and foresee that I will not have enough space in the main form to have 15 to 20 subforms if I were to have big dimensions for each subform.
Shrink the subforms so the height of each in design view is say 1cm and set CanGrow property = Yes. Possibly Can Shrink = Yes as well
However, that's a lot of subforms and it may not be very successful!
I do this with lots of subreports but never with multiple subforms underneath each other
A better approach may be to use a tabbed form with each tab containing one or perhaps two related subforms
Thanks! I ended up creating a tabbed form as the 1cm thing didn't work for me.