Results 1 to 2 of 2
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    Multi-select checkbox

    I was under the impression that the purpose of check boxes was to allow for multiple selections within a group. I have an options group which 15 check boxes, 3 rows and 5 values in each row. The 15 check boxes are labeled with various types of allergies. Since a person can have more than one allergy, I should allow for multiple selections.

    1. I cannot select more than one checkbox inside of this option group (these were all created in the same option group control that I added to my form).
    2. After I check a box, I cannot uncheck it.

    I don't want to use a listbox. I like the layout that I have. I can't find a property that seems to allow for multiple selections.



    I forgot to mention, each checkbox value is in its own field, therefore 15 checkboxes and 15 fields.
    Last edited by Access_Novice; 01-08-2014 at 12:01 AM. Reason: Forgot something.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,627
    Checkboxes and radio buttons within an option group are not bound to fields. The option group control is bound to field therefore there can be only one selection within the group.

    Multiple checkboxes indicates a non-normalized data structure and will give you a lot of trouble when you want to search records with multiple criteria.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Select All/ Clear All checkbox
    By TheHarleygirl2005 in forum Forms
    Replies: 11
    Last Post: 01-15-2013, 03:21 PM
  2. multi select list box
    By crowegreg in forum Forms
    Replies: 1
    Last Post: 07-28-2012, 11:52 PM
  3. Replies: 5
    Last Post: 07-26-2012, 12:59 PM
  4. Multi select box with several options
    By float in forum Programming
    Replies: 7
    Last Post: 10-04-2010, 07:33 AM
  5. Multi Update By Checkbox
    By Nsquared in forum Forms
    Replies: 3
    Last Post: 02-10-2010, 03:08 PM

Tags for this Thread

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