Results 1 to 5 of 5
  1. #1
    nightauthor is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    3

    Filter Combo Box Entries Based on Second Combo Box

    I have two combo boxes, I need the second to only display options with the same Z field as the item selected in the first combo box. How can I do this?

    Thanks for your help.

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You could use the after update event for the 1st combo and then change the record source for the 2nd combo. Of course you would also need to change it back once you use the 2nd combo.

    HTH

  3. #3
    nightauthor is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    3
    Thanks, that kind of helps. I am really new the access, im somewhat familiar with programming little things like Java applets and VB for minor excel projects. However, I am not sure how to format the row source such that it only shows the intended (matching) options based on the Z field.

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Example: Using the AfterUpdateEvent for cboCombo

    If Me.cboCombo0.Value = "something" Then
    Me.cboCombo1 = "something"
    End If
    HTH

  5. #5
    nightauthor is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    3
    Ok, I think that'll get me where I'm going. Thanks.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-18-2014, 10:40 AM
  2. Replies: 1
    Last Post: 10-01-2013, 09:25 PM
  3. Replies: 2
    Last Post: 09-24-2013, 11:38 AM
  4. Filter based on two combo boxes.
    By jakeao in forum Programming
    Replies: 1
    Last Post: 05-22-2011, 10:56 AM
  5. filter form based on combo box
    By lloyddobler in forum Forms
    Replies: 8
    Last Post: 09-10-2009, 07:33 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