Results 1 to 6 of 6
  1. #1
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52

    Checkbox

    Hi,



    Can you help me with the code for the following:

    When I tick checkbox A then checkbox B, C, D etc. will automatically be ticked as well. When I un-tick checkbox A then the opposite must happen.

    Thank you very much!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would use the AfterUpdate event of CheckBox A to achieve this. Have you tried that yet?

  3. #3
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52
    Thanks Rural.

    I am a newbie so you have to be more specific :-)

    Where to write what?

    Thank you!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Find the AfterUpdate event in the property sheet of the CheckBox and press the "..." button and select code. then your procedure will look something like:
    Me.CheckBoxB = Me.CheckBoxA
    Me.CheckBoxC = Me.CheckBoxB
    ...etc

  5. #5
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52
    Yes, it works!

    Thank you very much.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad we could help.

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

Similar Threads

  1. Checkbox in forms
    By adi.shoukat in forum Forms
    Replies: 1
    Last Post: 03-02-2010, 10:58 AM
  2. Using a checkbox help
    By gbjc105 in forum Forms
    Replies: 1
    Last Post: 01-28-2010, 08:27 PM
  3. Checkbox not working
    By terryvanduzee in forum Programming
    Replies: 4
    Last Post: 10-23-2009, 10:36 AM
  4. Checkbox
    By Rbtsmith in forum Access
    Replies: 2
    Last Post: 02-17-2009, 04:19 PM
  5. checkbox
    By Suresh in forum Forms
    Replies: 0
    Last Post: 12-19-2007, 01:30 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