Results 1 to 2 of 2
  1. #1
    zoom14151 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2013
    Posts
    1

    filtering combo box values with option group checkboxes


    I have a form with a combo box that uses a lookup table for its values. The lookup table has three yes/no fields (Days,Afternoons, and Midnights) and have the same checkboxes in the option group. I need the combo box values to display the values based on the checkbox selected inside the option group.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Can any record have any or all of the checkboxes as Yes? If not, then should be only one field with 3 value options.

    Otherwise, try this for combobox RowSource:

    SELECT field(s) FROM tablename WHERE IIf([Days],1,IIf([Afternoons],2,IIf([Midnights],3,4)))=[OptionGroup name];
    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. Use Option Group to Filter Combo Box Values
    By dgj32784 in forum Programming
    Replies: 2
    Last Post: 06-06-2011, 12:04 PM
  2. Resetting Option Group Values
    By oleBucky in forum Forms
    Replies: 4
    Last Post: 03-31-2011, 05:19 PM
  3. option group default values
    By wlumpkin in forum Access
    Replies: 3
    Last Post: 02-15-2011, 03:30 PM
  4. option group default values
    By wlumpkin in forum Access
    Replies: 6
    Last Post: 02-07-2011, 06:07 PM
  5. Combo Box and Option Group Values
    By Desstro in forum Queries
    Replies: 8
    Last Post: 09-06-2010, 11:40 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