Results 1 to 3 of 3
  1. #1
    roarcrm is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2014
    Posts
    27

    Checkbox based on Combo Box

    Hi all,



    I have a combo box with around 50 values in, for around 7 or 8 of these values I want a checkbox on the form to be automatically ticked when it is selected. Is this possible and if so, how?

    Thanks.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    in the combo afterupdate event put the following pseudo code - replace names as required

    Code:
    select case combo
        case "A","B","C"
            checkbox=true
        case else
            checkbox=false
    end select

  3. #3
    roarcrm is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2014
    Posts
    27
    Quote Originally Posted by Ajax View Post
    in the combo afterupdate event put the following pseudo code - replace names as required

    Code:
    select case combo
        case "A","B","C"
            checkbox=true
        case else
            checkbox=false
    end select
    That's brilliant, working great now.

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

Similar Threads

  1. AfterUpdate Event Based on Checkbox
    By lisa071 in forum Forms
    Replies: 3
    Last Post: 03-27-2015, 01:12 PM
  2. Query Based on Form Checkbox
    By tylerpickering in forum Queries
    Replies: 4
    Last Post: 11-11-2014, 09:32 AM
  3. Replies: 2
    Last Post: 10-28-2014, 03:55 AM
  4. Query sums based on checkbox criteria?????
    By mrmims in forum Queries
    Replies: 2
    Last Post: 07-06-2014, 02:42 PM
  5. Replies: 7
    Last Post: 11-26-2010, 07:54 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