Filtering Combo Boxes/ No Duplicates

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Eeek
    New Member
    • Feb 2007
    • 27

    Filtering Combo Boxes/ No Duplicates

    I have a form (frmOrder) which uses a subform, tblOrderLine, the field 'Product Type' is stored in tblProducts, I have a combo box (cboPType) which is linked to the product type field in tblProducts, however it contains repeated types (i.e. 30 books, 5 DVD's); I would like to filter the next combo box (combo68) which contains a list of products (linked to tblProducts) and, i would like to filter the combo box, so that if, say books are selected in the product type, the actual products list will change...how can i do this?
    I'm new to Access so any help will be hugely appreciated THANKS IN ADVANCED!!!!
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32633

    #2
    Check out this tutorial (Example Filtering on a Form.) and let me know if that helps you to do what you need.
    Remember, we can be more precise if required so don't be put off if it's beyond you at the moment.

    Comment

    Working...