Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954

    Quote Originally Posted by Tippzee View Post
    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?
    No it isn't.
    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.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    @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.

  3. #18
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi micron
    I hate to nit pick(!) but haven't you just made the same point as me...or have I misread your answer?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #19
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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

  5. #20
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I think you went backwards in time ...
    I think it's a toss up who is more befuddled....

    Anyway...we agree ....I think! Hooray!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #21
    Tippzee is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    12
    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.

  7. #22
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #23
    Tippzee is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    12
    Thanks! I ended up creating a tabbed form as the 1cm thing didn't work for me.

  9. #24
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Glad it's working. Tabbed forms is a better solution in my view
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. hide record if checkbox is unchecked
    By enginerdUNH in forum Programming
    Replies: 2
    Last Post: 02-26-2018, 08:00 PM
  2. Replies: 7
    Last Post: 03-17-2016, 10:42 AM
  3. Print Checkbox on report only if checked
    By azhar2006 in forum Reports
    Replies: 5
    Last Post: 10-26-2014, 11:59 PM
  4. Replies: 4
    Last Post: 06-03-2014, 10:30 AM
  5. Replies: 3
    Last Post: 08-06-2012, 04:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums