Results 1 to 3 of 3
  1. #1
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9

    Checkbox checked


    Hi all, i have 5 different checkboxes called checkbox1, checkbox2, checkbox3, checkbox4 and checkbox5. However, is there a way to enable the checkbox once the previous checkbox is checked? for example, once checkbox1 is checked, checkbox2 will be enabled but 3,4 and 5 is disabled. Thank you in advance.

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    When entering data this can be done using the After Update event of each checkbox, where you enable the next one, for example:

    Code:
    If me!checkbox2 = True then
      me!checkbox3.enabled = True
    endif
    That's OK if you only want to deal with checking a box.

    But if you Uncheck it, it gets messy, because in that case you have to a) uncheck all following checkboxes and then b) disable all the following checkboxes.

    You would probably also need to put similar code in the On Current event of the form, to set the proper boxes to be Enabled when you move to another record.

  3. #3
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9
    thank you so much. i managed to do it

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

Similar Threads

  1. Checkbox Always Shows Checked
    By jo15765 in forum Forms
    Replies: 3
    Last Post: 08-16-2016, 06:58 AM
  2. Checkbox data in query: only when checked
    By AsjenW in forum Queries
    Replies: 1
    Last Post: 04-19-2013, 07:43 AM
  3. If checkbox is checked allow query to run
    By burrina in forum Forms
    Replies: 14
    Last Post: 01-29-2013, 03:56 PM
  4. VBA for testing if checkbox is checked
    By rhewitt in forum Programming
    Replies: 0
    Last Post: 09-26-2012, 07:11 AM
  5. If checkbox is checked, add X to a current value
    By INeedAboutTreeFiddy in forum Programming
    Replies: 4
    Last Post: 05-30-2012, 08:17 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