Results 1 to 4 of 4
  1. #1
    Adish is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2015
    Posts
    15

    Multiple Checkbox selected at once

    Hi All

    I have a subform in datasheet view in a form. I have checkboxes that I want to use to update and end the checked address. But when I select one checkbox all gets selected. I only need one to be selected to change or update. I have a screen shot attached and the arrow pointing to the one I want to change but all checkbox gets selected. I have hidden all addresses for privacy reasons.
    Attached Thumbnails Attached Thumbnails checkbox_select.png  

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    The checkbox would have to be bound to a field in the underlying table to have a distinct value record-by-record. If the field is there, simply bind the checkbox. If not, run a process behind a button or something.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Adish is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2015
    Posts
    15
    The column address_CTR is the address id to which I have bound the checkboxes but now both are ckecked on load. The end and update checkboxes and does not allow me to click on it to uncheck

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I meant a Yes/No field in the table that held those values. What is it exactly you want to happen when one is checked?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Show Checkbox when listbox item is selected
    By gammaman in forum Modules
    Replies: 5
    Last Post: 06-04-2015, 09:46 AM
  2. Query form with multiple Checkbox
    By mesba713 in forum Access
    Replies: 1
    Last Post: 03-24-2015, 07:20 AM
  3. Replies: 9
    Last Post: 01-03-2013, 04:04 PM
  4. Multiple checkbox filtering & Clearing
    By Havvix in forum Access
    Replies: 3
    Last Post: 12-05-2012, 04:42 PM
  5. Insert Multiple Checkbox Values to one Textbox
    By dshillington in forum Programming
    Replies: 1
    Last Post: 12-28-2011, 10:10 AM

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